OraFAQ Forum: Forms » Can I detect an Event or trigger inside a trigger action

Home » Developer & Programmer » Forms » Can I detect an Event or trigger inside a trigger action

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

Can I detect an Event or trigger inside a trigger action [message #123825]

Wed, 15 June 2005 00:53

sneha_84
Messages: 21
Registered: May 2005

Junior Member

Can I detect an Event or trigger inside a trigger action

as ***** red below.

cursor myCursor is select name from test;
begin
go_block('block9');
open myCursor;

First_record;

loop
fetch myCursor into name1;
:text_item10 := name1;
exit when myCursor%NOTFOUND or *****up on an event occur exit;
synchronize;
Next_record;
end loop;
end;

Report message to a moderator

Re: Can I detect an Event or trigger inside a trigger action [message #123826 is a reply to message #123825]

Wed, 15 June 2005 00:53

sneha_84
Messages: 21
Registered: May 2005

Junior Member

action

Report message to a moderator

Re: Can I detect an Event or trigger inside a trigger action [message #123833 is a reply to message #123826]

Wed, 15 June 2005 01:10

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Do you HAVE to populate the block this way??

Just base the block on the table in which you are interested and the form will do the rest.

David

Report message to a moderator

Re: Can I detect an Event or trigger inside a trigger action [message #123841 is a reply to message #123833]

Wed, 15 June 2005 01:34

sneha_84
Messages: 21
Registered: May 2005

Junior Member

I could'nt follow this.

My objective is to trap an event insid the trigger itself.

Do you HAVE to populate the block this way??

Just base the block on the table in which you are interested and the form will do the rest.

David

Report message to a moderator

Re: Can I detect an Event or trigger inside a trigger action [message #123842 is a reply to message #123841]

Wed, 15 June 2005 01:39

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

I don't believe that you can trap an event inside a trigger.

David

Report message to a moderator

Previous Topic:	printing oracle forms data to excel
Next Topic:	Need Admin Panel Sample Application

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 05:33:02 CDT 2024