Home » Other » Training & Certification » when form builder open which trigger will fire first and last
when form builder open which trigger will fire first and last [message #274895] Wed, 17 October 2007 10:56 Go to next message
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 #274898 is a reply to message #274895] Wed, 17 October 2007 10:59 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
1) When Form BUILDER opens, I really really hope no triggers fire.!
3) Does not make sense.
5) DON'T do that.
7) See 3)

The rest: homework
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 Go to previous messageGo to next message
Littlefoot
Messages: 20888
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.
Re: when form builder open which trigger will fire first and last [message #275005 is a reply to message #274935] Thu, 18 October 2007 01:51 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
I know you can use triggers in Reports, but the question is too general.
You cannot say in which trigger you run "your PL/SQL"
Re: when form builder open which trigger will fire first and last [message #275068 is a reply to message #275005] Thu, 18 October 2007 04:02 Go to previous message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
In that case, in any trigger you can run your PL/SQL code.
Previous Topic: NULL RESOLUTION
Next Topic: ORACLE APPS TECHNICAL TRAINING
Goto Forum:
  


Current Time: Sat Dec 03 11:46:46 CST 2016

Total time taken to generate the page: 0.11404 seconds