call a procedure on oracle bi publisher 12c

Osama Fawzy · Mar 16, 2020 7:52AM

Summary

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

Hello all,

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

i see this link

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.

12C

FPonte · Mar 16, 2020 8:05PM

Hi Osama.

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

Cheers

Fernando

Osama Fawzy · Mar 18, 2020 11:25AM

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