| |
GeekInterview.com > Interview Questions > Oracle > Oracle Forms 3.0
| Print | |
Question: What are User Exits ?
|
| August 08, 2005 01:37:09 |
#1 |
| Ranajit Sahoo |
Member Since: Visitor Total Comments: N/A |
RE: What are User Exits ?
|
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.
To incorporate a user exit into a form, you take the following steps:
Write the user exit in Pro*C.
Precompile the source code.
Compile the. c file from step 2.
Use the GENXTB utility to create a database table, IAPXTB.
Use the GENXTB form in SQL*Forms to insert your user exit information into the table.
Use the GENXTB utility to read the information from the table and create an IAPXIT source code module. Then compile the source code module.
Create a new SQL*Forms executable by linking the standard SQL*Forms modules, your user exit object, and the IAPXIT object created in step 6.
In the form, define a trigger to call the user exit
Instruct operators to use the new IAP when running the form. This is unnecessary if the new IAP replaces the standard one. |
| |
Back To Question | |
