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: 21148
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: Case is not working in Forms Why?
Next Topic: Repeat items
Goto Forum:
  


Current Time: Sat Aug 19 11:55:03 CDT 2017

Total time taken to generate the page: 0.16834 seconds