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

Facebook Twitter LinkedIn YouTube
Go
New
Search
Notify
Tools
Reply
  
Oracle functions
 Login/Join
 
Gold member
posted
Is it possible to call Oracle functions from Webfocus? If so, what method should I use?

Thanks
 
Posts: 81 | Location: Calgary, Alberta | Registered: August 07, 2003Reply With QuoteReport This Post
<Grzegorz>
posted
You can invoke Oracle stored procedures, whith some limitations described in the "iWay data administration manual ..." (v. 5.2, chapter 27. "Getting Started in Oracle"). There is also an example of the syntax.
IBI Tech Support link

If you would like to call the Oracle function (PL/SQL: CREATE FUNCTION), you can wrap the function within a PL/SQL procedure and then call it using SQL PASSTHROUGH from FOCUS.
 
Reply With QuoteReport This Post
  Powered by Social Strata  
 


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