call a procedure on oracle bi publisher 12c

Osama Fawzy

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

FPonte

Hi Osama.

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

Creating Non-Standard SQL Data Sets

Cheers

Fernando

Osama Fawzy

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