Tech Doc Search Tech Support User Forums WebFOCUS Newsletter Summit Education

IB - Developer Center    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     SQL Passthru: (FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF)
Go
New
Search
Notify
Tools
Reply
  
SQL Passthru: (FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF)
 Login/Join
 
Platinum Member
posted
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!


Sandy Kadish
Test: 7.7.01 - SQL SERVER 2008 SP3
UAT: 7.7.01 - SQL SERVER 2008 SP3
Prod: 7.7.01 - SQL SERVER 2008 SP3
 
Posts: 175 | Location: Jacksonville, Florida | Registered: May 06, 2003Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Seems 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.


Leah
 
Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004Reply With QuoteReport This Post
Platinum Member
posted Hide Post
It 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.


Sandy Kadish
Test: 7.7.01 - SQL SERVER 2008 SP3
UAT: 7.7.01 - SQL SERVER 2008 SP3
Prod: 7.7.01 - SQL SERVER 2008 SP3
 
Posts: 175 | Location: Jacksonville, Florida | Registered: May 06, 2003Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Lesson 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.


Sandy Kadish
Test: 7.7.01 - SQL SERVER 2008 SP3
UAT: 7.7.01 - SQL SERVER 2008 SP3
Prod: 7.7.01 - SQL SERVER 2008 SP3
 
Posts: 175 | Location: Jacksonville, Florida | Registered: May 06, 2003Reply With QuoteReport This Post
  Powered by Social Strata  
 

IB - Developer Center    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     SQL Passthru: (FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF)

Copyright © 1996-2014 Information Builders, leaders in enterprise business intelligence.