|
Re: User_defined Trigger [message #298044 is a reply to message #297979] |
Mon, 04 February 2008 14:55   |
 |
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Yes, you can. I don't have Forms 6i, but I believe nothing changed much in 10g, so ...
Create it on any level (form/block/item) by "adding" a trigger (green plus tool) and choosing the "user named" trigger name. Or, create any trigger (post-query, key-commit, when-validate-item ... doesn't matter) and simply rename it to a more appropriate name (for example, 'my_trigger').
PL/SQL editor will open; enter PL/SQL code you want, compile and make sure there are no errors there.
Call your trigger by using the EXECUTE_TRIGGER built-in (for example, EXECUTE_TRIGGER('my_trigger');).
Is this what you were looking for?
|
|
|
|