March 21, 2011, 03:42 PM
RichaKulkarniRef cursor giving error
Hi,
I'm trying to call a ref cursor from WebFocus and while running the fex it asks me to "Find, Save or Cancel" and doesnt show me the resultset of the cursor.
Any idea what's happening?
Plese help!
Thanks
Richa
March 22, 2011, 02:51 AM
Ramkumar - WebfousCalling a REF cursor, u mean calling a DB stored proc which uses or return a REF cursor...
How you are doing that ? Whatz the error message ?
March 24, 2011, 04:24 PM
RichaKulkarnihere is the code
ENGINE SQLORA SET DEFAULT_CONNECTION conn_string
SQL SQLORA PREPARE SQLOUT FOR
SELECT * FROM TABLE(DB.RPT_PKG.RP_P('OC002', 'FSY', NULL, NULL, 'Yes', 'ALL', '28/02/2011'));
END