Focal Point
[SOLVED] Using oracle stored procedures

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

July 12, 2005, 11:19 AM
<mohith>
[SOLVED] Using oracle stored procedures
I have a doubt in this. Does WF only allow ref cursors to be used?? What happens if i have get columns from multiple tables and build some logic in that also, where i cannot use joins alone but need to do some sort of processing?

This message has been edited. Last edited by: <Kathryn Henning>,
July 13, 2005, 02:36 AM
Cyril Joy
Mohith,

To my knowledge WebFOCUS will only allow ref cursors as output from SQL procedure to be used in the fex procedure. You need to bring all ur output as cursor type from the Oracle procedure.
October 22, 2015, 02:37 PM
Ricardo Augusto
Like this

type HLHeader_type is ref cursor return recHLHeader;
type HLMain_type is ref cursor return recHLMain;

?


WebFOCUS 8.1.05 / APP Studio