Home » Developer & Programmer » Forms » Update in Pre-insert trigger
Update in Pre-insert trigger [message #216720] Tue, 30 January 2007 02:44 Go to next message
Messages: 27
Registered: December 2006
Junior Member
I perform a loop thru a block of records on a form.ie.
loop ...............
This can only be done before I insert the record into the database. The the PRE-INSERT trigger does not allow go_block.

How else can this be done.

Re: Update in Pre-insert trigger [message #216723 is a reply to message #216720] Tue, 30 January 2007 02:48 Go to previous messageGo to next message
Messages: 20850
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Perhaps you don't need GO_BLOCK restricted procedure at all - make this PRE-INSERT trigger a block-level one (attached to the 'abc' block) and do what you have to. Just to mention: it is not only the GO_BLOCK that is not allowed - there are other restricted procedures too.
Re: Update in Pre-insert trigger [message #217151 is a reply to message #216720] Wed, 31 January 2007 18:54 Go to previous message
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Why do you need to loop through the records? What is the problem that you are trying to solve?

Previous Topic: Oracle Forms Designer has encountered a problem and needs to close.We are sorry for the inconvenienc
Next Topic: Validation problem in Non-dataBase block
Goto Forum:

Current Time: Sun Oct 23 11:51:14 CDT 2016

Total time taken to generate the page: 0.08397 seconds