What could be the reason for the error?

You created the SALES_ORDERS_CTX context to use the
OE.SALES_ORDERS_PKG package.
View Exhibit1 and examine the package that is used with the context.
View Exhibit2 to examine the policy defined and the logon trigger.
A user receives the following error when he or she executes a query:
ERROR at line 2:
ORA-28112: failed to execute policy function
What could be the reason for the error?

You created the SALES_ORDERS_CTX context to use the
OE.SALES_ORDERS_PKG package.
View Exhibit1 and examine the package that is used with the context.
View Exhibit2 to examine the policy defined and the logon trigger.
A user receives the following error when he or she executes a query:
ERROR at line 2:
ORA-28112: failed to execute policy function
What could be the reason for the error?

A.
The user has insufficient privileges on the DBMS_SESSION package.

B.
The subprograms inside the package have not been created with the invoker’s 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.



Leave a Reply 1

Your email address will not be published. Required fields are marked *