BI Publisher (MOSC)

MOSC Banner

BI Publisher (OBIEE), Data Model, Event trigger, PL/SQL unable to see package

edited Jan 16, 2015 10:02AM in BI Publisher (MOSC) 5 commentsAnswered

Hi,

Trying to sort this one out and looking for some input.  In OBIEE 11g, BI Publisher (version 11.1.1.7.141014) I've created a datasource JDBC connection to a Oracle 9i database. For this discussion lets call it 'OLDDB' and the user is 'olduser'.

  I create a data model...

Specify the default data source as OLDDB.

Set the Oracle DB Default Package to "OTHERUSER.Report_Package"

Use a 'Before Data' Event trigger, Language PL/SQL

Under the Available functions it does not show the package.

Package contains a function returning a boolean.

If I create that same package in the schema 'olduser',  I can see it and select it.

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