BI Publisher (MOSC)

MOSC Banner

How to execute DB stored procedures from Oracle BI Publisher?

edited Jan 31, 2010 4:10PM in BI Publisher (MOSC) 1 commentAnswered
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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center