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
ora_dev
Messages: 27
Registered: December 2006
Junior Member
I perform a loop thru a block of records on a form.ie.
go_block('ABC');
first_record;
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.

Thanks
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
Littlefoot
Messages: 20897
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
djmartin
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?

David
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: Wed Dec 07 02:46:09 CST 2016

Total time taken to generate the page: 0.13562 seconds