OraFAQ Forum: Forms » alter database trigger in forms

Home » Developer & Programmer » Forms » alter database trigger in forms

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

alter database trigger in forms [message #157200]

Wed, 01 February 2006 00:20

poison_ivy
Messages: 1
Registered: January 2006

Junior Member

i would like to ask how to alter database trigger inside a form? I tried the command Forms_DDL('BEGIN ALTER TRIGGER "TRIGGERNAME" ENABLE; END;'); but it did not work. Do you have any suggestions? Thanks!

Report message to a moderator

Re: alter database trigger in forms [message #157208 is a reply to message #157200]

Wed, 01 February 2006 01:01

vban2000
Messages: 207
Registered: March 2005

Senior Member

Hi

Try this..

Forms_DDL('ALTER TRIGGER TRIG_NAME ENABLE');

(1) remove the BEGIN and END; you don't need them.
(2) remove the ; - you don't need them.
(3) remove the '' around the TRIGGER_NAME you have - you don't need them, also.

Regards
AnDy

Report message to a moderator

Previous Topic:	How to determine client IP address?
Next Topic:	Transfer data from forms6i to excel & image item (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 05:39:42 CDT 2024