BI Publisher (OBIEE), Data Model, Event trigger, PL/SQL unable to see package
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.