Identify which Packaged procedure is Unrestricted?

Options
- EXECUTE_QUERY
- CLEAR_BLOCK
- USER_EXIT
- CALL_INPUT


CORRECT ANSWER : USER_EXIT

Discussion Board
Package Procedure

A Package procedure is built in PL/SQL procedure. There are two types of Package Procedure:
1. Restricted package procedure: Restricted package procedure affects the basic functions of SQL * Forms. It cannot use in all triggers except key triggers.

2. Unrestricted package procedure: Unrestricted package procedure does not interfere with the basic functions of SQL * Forms. It can be used in any triggers.

Following are the list of restricted and unrestricted procedure:
a. Call - unrestricted
b. User Exit - Unrestricted
c. Call_query - Unrestricted
d. Break - Unrestricted

e. Up - Restricted
f. Execute Query - Restricted
g. Message - Restricted
h. Exit_form - Restricted
i. Post - Restricted

Prajakta Pandit 02-28-2017 03:38 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement