ExamQuestions.com

Register
Login
Oracle Database 11g Advanced PLSQL Exam Questions

Oracle

Oracle Database 11g Advanced PLSQL

25 / 68

Question 25:

See the Exhibit: Exhibit1: 
image
Exhibit2: 
image
When executing the above PL/SQL statement to create SALES_ORDERS_CTZ context to use the OE.SALES_ORDERS_PKG package. ERROR at line 2: ORA-28112: Failed to execute policy function. What could be the reason for the error? 

Answer options:

A. The user has insufficient privileges on the DBMS_SESSION package
B. The subprograms inside the package have not been created with the invokers right
C. The THE_PREDICATE function has an insufficient number of parameters in the package
D. The policy is created by using SALES_ORDERS_PKG. THE_PREDICATE without a parameter