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