Focal Point
[CLOSED] Unable to execute oracle function returning cursor

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9707014036

April 25, 2013, 05:06 AM
Sourabh Mukherjee
[CLOSED] Unable to execute oracle function returning cursor
Hi,

I need to run oracle function which returns a cursor. I need the cursor returned as the data in report.
Conventionally I was trying
ENGINE SQLORA SET DEFAULT_CONNECTION FILEAGD1
SQL SQLORA PREPARE SQLOUT FOR
select ABC.DEF_GHG_TAX_FX() from dual;
END
-RUN
TABLE FILE SQLOUT
PRINT
*
ON TABLE PCHOLD FORMAT EXL2K
END
-RUN

BUT THIS IS NOT WORKING AND THE ERROR THROWN IS LIKE
(FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF)
L (FOC1405) SQL PREPARE ERROR.
TABLE FILE SQLOUT
PRINT
*
ON TABLE PCHOLD FORMAT EXL2K
END
-RUN
(FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: SQLOUT
BYPASSING TO END OF COMMAND
-EXIT

This message has been edited. Last edited by: <Kathryn Henning>,


WebFOCUS 7.6
Windows, All Outputs
April 30, 2013, 12:50 PM
Rao D
Does FILEAGD1 (which is your connection to the database ) user has access to the function that you are trying to run?


WebFOCUS - ver8201
[ReportingServers: Windows 64bit;
Client: tomcat and IIS on windows 2012
AppStudio

April 30, 2013, 12:56 PM
Danny-SRL
I would try this:
ENGINE SQLORA SET DEFAULT_CONNECTION FILEAGD1
SQL SQLORA PREPARE SQLOUT FOR
select ABC.DEF_GHG_TAX_FX() from dual;
TABLE FILE SQLOUT
PRINT
*
ON TABLE PCHOLD FORMAT EXL2K
END
-RUN
  



Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF