Calling Trigger [message #608554] |
Fri, 21 February 2014 01:02 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/156655.jpg) |
randriana
Messages: 18 Registered: September 2010
|
Junior Member |
|
|
Hi everybody,
I'd like to ask if it is possible to call "WHEN-BUTTON-PRESSED" trigger or other in another trigger on a form 10g, i mean for example:
in a WHEN-MOUSE-CLICK trigger on a block is it possible to do any code like "call when-button_pressed" like in a VB code.
|
|
|
Re: Calling Trigger [message #608561 is a reply to message #608554] |
Fri, 21 February 2014 01:21 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Yes, but not the way you put it.
The simplest way is to put code that now resides in WHEN-BUTTON-PRESSED trigger into a (form) procedure and then call that procedure from a WHEN-BUTTON-PRESSED trigger or any other trigger you find appropriate.
Otherwise, you'd have to create a trigger having your own name - its name can't have a minus "-" sign - you'd have to use underscore "_" instead as "minus" is reserved for Oracle. So, you could name it RANDIANA_TRIGGER and then call it with EXECUTE_TRIGGER built-in (read more about it in Forms Online Help under the "User-Named Trigger" section).
Although you can call built-in triggers as well, this is not recommended. Therefore, my opinion is that the first option I suggested (a procedure) is a better one.
[Updated on: Fri, 21 February 2014 01:22] Report message to a moderator
|
|
|
|
|