InterviewSolution
| 1. |
What Are User-exits? |
|
Answer» A USER exit is a C subroutine written by you and called by Oracle Forms to do special-purpose processing. You can EMBED SQL STATEMENTS and PL/SQL blocks in your user exit, then precompile it as you WOULD a host program. When called by an Oracle Forms V3 trigger, the user exit runs, then returns a status code to Oracle Forms. Your exit can display messages on the Oracle Forms status line, get and set field values, do high-speed computations and table lookups, and MANIPULATE Oracle data. A user exit is a C subroutine written by you and called by Oracle Forms to do special-purpose processing. You can embed SQL statements and PL/SQL blocks in your user exit, then precompile it as you would a host program. When called by an Oracle Forms V3 trigger, the user exit runs, then returns a status code to Oracle Forms. Your exit can display messages on the Oracle Forms status line, get and set field values, do high-speed computations and table lookups, and manipulate Oracle data. |
|