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>,
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.
type HLHeader_type is ref cursor return recHLHeader;
type HLMain_type is ref cursor return recHLMain;
WebFOCUS 8.1.05 / APP Studio
|Powered by Social Strata|