How to execute DB stored procedures from Oracle BI Publisher?
In Oracle Business Intelligence Publisher Enterprice I would like to generate a report that pick up data from a Data Base just executing a custom stored procedure.
So far, in OBI, I am able to generate reports taking data from an external file, or from a DB view but not by executing a stored procedure.
The stored procedure I created contains some input parameter. It works fine and I can successfully execute it externally to OBI (from OSM scripter tool or directly from DB).
I guess OBI could manage this kind of work and I don't want to crete custom OBI functionalities.
So far, in OBI, I am able to generate reports taking data from an external file, or from a DB view but not by executing a stored procedure.
The stored procedure I created contains some input parameter. It works fine and I can successfully execute it externally to OBI (from OSM scripter tool or directly from DB).
I guess OBI could manage this kind of work and I don't want to crete custom OBI functionalities.
0