Home » Developer & Programmer » Forms » User_defined Trigger (developer 6i second release)
User_defined Trigger [message #297979] Mon, 04 February 2008 06:50 Go to next message
ashraf_al_ani
Messages: 92
Registered: October 2007
Location: Iraq
Member
Dear All
can I create my own user_defined_trigger ?
if yes how ? pls

best regards
Re: User_defined Trigger [message #298044 is a reply to message #297979] Mon, 04 February 2008 14:55 Go to previous messageGo to next message
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?
Re: User_defined Trigger [message #298530 is a reply to message #297979] Wed, 06 February 2008 05:16 Go to previous message
ashraf_al_ani
Messages: 92
Registered: October 2007
Location: Iraq
Member
thanks brother

you are great

best regards
Previous Topic: Position of form changes in browser
Next Topic: How i can Upgrade to 10g
Goto Forum:
  


Current Time: Mon Feb 17 05:33:45 CST 2025