April 26, 2004, 10:24 PMNightowl
Is it possible to call Oracle functions from Webfocus? If so, what method should I use?
April 28, 2004, 08:33 AM<Grzegorz>
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.