BI Publisher (MOSC)

MOSC Banner

passing database package results to BI Publisher data model

edited Jan 28, 2016 10:02AM in BI Publisher (MOSC) 3 commentsAnswered

I am new to BI Publisher server, I have been using  BI Publisher servlet that was embeded in Oracle Transportation Management. This has been discontuniued in the latet release.

When using the embeded servlet I could pass a variable to a database package using a report trigger and then assigning the result to a variable for use the query.

For example, I have a function that takes a string and parses it apart to return a substring.  I can then use the substring in my query.

How do you do this when using the BI Publisher server?

I see I can use the trigger before the report runs but how do I access the results of my package function?

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