call a procedure on oracle bi publisher 12c

Question

Summary

oracle bi publisher add Global-Level Element by PL/SQL

Content

Hello all,

How to call a procedure that return multiple parameters on oracle bi publisher data model.

i see this link

https://docs.oracle.com/middleware/12212/bip/BIPDM/GUID-7AB19BAC-5506-4FBB-B9B1-03FF875EBC3C.htm#BIPDM296

demonstrated that to add a Global-Level Element by PL/SQL after specify Oracle DB Default Package in properties,

but i still don't know how to call this expression in the DataSet ?

Thanks in advance.

Version

12C

Osama Fawzy · Answer

Thanks Fernando, i follow the link and it works well.

FPonte · Answer

Hi Osama.

Check the following link for Non-Standard SQL Data Sets.

Creating Non-Standard SQL Data Sets

Cheers

Fernando