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>,

Does FILEAGD1 (which is your connection to the database ) user has access to the function that you are trying to run?

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