when form builder open which trigger will fire first and last [message #274895] |
Wed, 17 October 2007 10:56 |
nagoorsasi
Messages: 3 Registered: October 2007 Location: kadapa
|
Junior Member |
|
|
hi,
i am sasi, i have some doubts any one please clarify them.
Quesitions are:
1.when form builder open which trigger will fire first and last
2.when we close form window which trigger will fire
3. Where will you execute your plsql code in reports i.e. in which trigger
4.in form 6i instead of run_product we will use another one for call report what is that
5.how create table in pl/sql and is there any package
6.can we use exception in exception block
7.How to delete the columns in a table using sql * loader
8.I developed 2 files ,In first file i have 10 records
and in second file 20 records, How can i pass these records
into 2 tables using sql*loader?
|
|
|
|
Re: when form builder open which trigger will fire first and last [message #274935 is a reply to message #274898] |
Wed, 17 October 2007 14:40 |
|
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Quote: | Q3: Where will you execute your plsql code in reports i.e. in which trigger
A3: Does not make sense.
|
Actually, there is a possibility to run PL/SQL code in a report (written by Reports Builder).
First, there are several report triggers (BEFORE REPORT, AFTER PARAMETER FORM, etc.).
Also, you can create program units (including packages, procedures, functions, ...) which also contain PL/SQL code.
Finally, formula columns as well as object format triggers represent PL/SQL functions.
|
|
|
|
|