Solved

Difference between When-New-Record-Instance and pre-record trigger

Posted on 2013-12-23
5
2,789 Views
Last Modified: 2014-01-11
Difference between When-New-Record-Instance and pre-record trigger, fire in the same sequence , if possible please explain me.


Thanks in Advance
Hina mansoor
0
Comment
Question by:hinamansoor
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 12

Accepted Solution

by:
praveencpk earned 250 total points
ID: 39737892
Pre-Record Trigger Fires during the Enter the Record process, during navigation to a different record.

When-New-Record-Instance Trigger Fires when the input focus moves to an item in a record that is different than the record that previously had input focus.

Check the below doc mor info

https://community.oracle.com/thread/2186403?tstart=0
0
 
LVL 9

Assisted Solution

by:MarkusId
MarkusId earned 250 total points
ID: 39737997
Also have a look at the following link - section 'Navigational triggers'. Whereas Pre-Record-Trigger also fires during internal navigation, When-New-Record-Instance trigger does not:

http://kashif-oracle-forms.blogspot.co.at/2009/07/types-of-triggers-in-forms.html
0
 
LVL 12

Expert Comment

by:praveencpk
ID: 39738337
i think there should be split of points as i have also highlighted the same.
0
 

Author Comment

by:hinamansoor
ID: 39738937
Yes @: praveencpkP   you are right thanks for your answered 2



Thanks
Hina mansoor
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and theā€¦
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question