OraFAQ Forum: Forms » Update in Pre-insert trigger

Home » Developer & Programmer » Forms » Update in Pre-insert trigger

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Update in Pre-insert trigger [message #216720]

Tue, 30 January 2007 02:44

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

Report message to a moderator

Re: Update in Pre-insert trigger [message #216723 is a reply to message #216720]

Tue, 30 January 2007 02:48

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: Update in Pre-insert trigger [message #217151 is a reply to message #216720]

Wed, 31 January 2007 18:54

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 19:09:40 CST 2025