Focal Point
Ref cursor giving error

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

March 21, 2011, 03:42 PM
RichaKulkarni
Ref 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 Confused


Thanks,
Richa

WebFOCUS 7.6
Windows, All Outputs
March 21, 2011, 05:18 PM
Waz
How are you doing this ?

Can you post the code ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

March 22, 2011, 02:51 AM
Ramkumar - Webfous
Calling 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 ?


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
March 24, 2011, 04:24 PM
RichaKulkarni
here 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


Thanks,
Richa

WebFOCUS 7.6
Windows, All Outputs