Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Using oracle stored procedures
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Using oracle stored procedures
 Login/Join
 
<mohith>
posted
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>,
 
Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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.
 
Posts: 143 | Location: Rochester,NY. | Registered: August 20, 2004Reply With QuoteReport This Post
Guru
posted Hide Post
Like this

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

?


WebFOCUS 8.1.05 / APP Studio
 
Posts: 272 | Location: Brazil | Registered: October 31, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Using oracle stored procedures

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.