Oracle Forms 3.0 - What are User Exits ?

GeekInterview.com > Interview Questions > Oracle > Oracle Forms 3.0

Go To First | Previous Question | Next Question

Oracle Forms 3.0 | Question 61 of 66

What are User Exits ?

Total Answers and Comments: 4

Last Update: September 16, 2008

Sponsored Links

Best Rated Answer

—

Submitted by: Devi Prasad Mishra

User Exits is a program which is used to pass the control from the Report Builder to a third generation language for performing complex calculations and returning the value back to the Report Builder.

Above answer was rated as good by the following members:
sumanpani

August 23, 2005 00:38:09

Joby

RE: What are User Exits ?

Userexits are ProC code library. Once the user exit is called then the control goes into the library. This has been very stable.

Is this answer useful? Yes | No

August 23, 2005 01:37:09

Ranajit Sahoo

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.

Is this answer useful? Yes | No

September 30, 2005 03:22:27

Devi Prasad Mishra

RE: What are User Exits ?

User Exits is a program which is used to pass the control from the Report Builder to a third generation language for performing complex calculations and returning the value back to the Report Builder.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

September 16, 2008 02:36:37

sumanpani

Member Since: September 2008 Contribution: 11

RE: What are User Exits ?

A user exit is a program that you write and then link into the Report Builder executable or user exit DLL files. You build user exits when you want to pass control from Report Builder to a program you have written which performs some function and then returns control to Report Builder.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank