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?

Question

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?

Accepted Answer

C. The THE_PREDICATE function has an insufficient number of parameters in the package.

Answer

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

Answer

B. The subprograms inside the package have not been created with the invoker's right.

Answer

D. The policy is created by using SALES_ORDERS_PKG.THE_PREDICATE without a parameter.

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…

Question

Options

How the community answered

Community Discussion