How can I add an Oracle Function into my existing universe that already has many tables and dynamic tables in it, tables linked by foreign keys?
This oracle function returns a cursor (recordset). The function returns a set of records from a Country table and code for the function is:
CREATE OR REPLACE FUNCTION TEST_FUNCTION1 (PARAM1 IN VARCHAR2) RETURN SYS_REFCURSOR
OPEN my_cursor FOR SELECT * FROM COUNTRY;
What would be an efficient way to add this oracle function into my existing Universe model, so I can build Webi reports based on it (to get my report to show list of countries that my function returns)?
Please note that this function above is just a simplified one, and that my real function is more complex, involves applying calculations on the table fileds, and has much longer code. But the concept is the same, the real function returns a sys_refcursor set of records too, so the same solution should be good.
I work with BOE XI 3.1 SP6 , Universe Designer 188.8.131.522 and Oracle 11.2.