Post-field trigger fires whenever the control leaving from the filed.Post-change trigger fires at the time of execute-query procedure invoked or filed validation status changed.
Key-startup trigger fires after successful navigation into a form.Pre-form trigger fires before enter into the form. PACKAGE PROCEDURE & FUNCTION
A Package procedure is built in PL/SQL procedure.
1. Restricted package procedure. 2. Unrestricted package procedure.
What is the difference between restricted and unrestricted package procedure ?
Restricted package procedure that affects the basic functions of SQL * Forms. It cannot used in all triggers except key triggers. Unrestricted package procedure that
Classify the restricted and unrestricted procedure from the following. a. Call b. User-Exit c. Call-Query d. Up e. Execute-Query f. Message g. Exit-From h. Post i. Break a. Call - unrestricted b. User Exit - Unrestricted c. Call_query
No.
It synchronizes the terminal screen with the internal state of the form.
Enter Validate-data in the current validation unit.
Erase removes an indicated global variable.
