Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

BI Publisher and global level PLSQL function

Received Response
113
Views
1
Comments
User_2KH5J
User_2KH5J Rank 1 - Community Starter
edited Aug 13, 2024 5:13PM in Oracle Analytics Cloud and Server

Hi All,

I have a PLSQL package which has a global function (All package variables are global).

I have a before report trigger where I need to populate the data and then run the report.

I have  schema emp where my package resides.  I have another schema BIP_READ_ONLY  which has read access to emp.

I have created a public synonym for the package and given the execute rights to schema BIP_READ_ONLY.

I am able to select this package as the default database package in the BIP Data model.

However when I create the report trigger and call the  package, I get below error

  Processing Exceptions: oracle.xdo.XDOException: Invalid PLSQL function call. 

  Only global level PLSQL function calls are allowed. Please check PLSQL function definition

Anyone seen this earlier ?

Thank you

Best Regards

Rajesh Alex

Answers