July 24, 2006, 12:53 PM
S.J. KadishSQL Passthru: (FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF)
I have an SQL query that runs fine using Rapid*SQL but the job bombs when plugged in as SQL passthru. The TechResponse solutions suggestion an upgrade to Oracle Client 9.2.0.4 but we are already at Oracle Client 9.2.0.5.
Other notes:
1.) The SQL passthru is notably smaller than the 64K limitation for SQL queries.
2.) The complete message shows:
(FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF)
(FOC1407) SQL FETCH CURSOR ERROR. : SQLOUT
3.) For security reasons I cannot post the code. However I can respond to a private query.
4.) I tried a number of settings for SQLORA, e.g. DATETIME OFF but to no avail.
5.) The best answer results in a prize granted at Summit 2007 in Las Vegas.
TIA - FOCUS nation knows!
July 24, 2006, 01:08 PM
LeahSeems to me I've seen something similar in our DB2 environment whent the security settings for the pass to DB2 didn't include access to a table in the environment.
Don't know how that would apply to your oracle issue. I got the error just in WebFOCUS, don't do passthru.
July 24, 2006, 01:46 PM
S.J. KadishIt is probably not security because the code runs fine through Oracle but I will check on the EDASPROF to see if there are issues there.
Also, worth noting, I tried to run the code in the SQL Report Builder in Dev Studio and the same errors occur.
July 25, 2006, 07:49 AM
S.J. KadishLesson learned:
Just because code runs correctly in a SQL query tool, such as Rapid SQL, is no guarantee that it will execute correctly as SQL passthru. It is best to break down the retrieval into components and add each one individually to confirm that the focexec will run.