OraFAQ Forum: Forms » disable a database trigger from the form

Home » Developer & Programmer » Forms » disable a database trigger from the form

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

disable a database trigger from the form [message #277207]

Mon, 29 October 2007 04:20

sh_eng
Messages: 15
Registered: May 2006

Junior Member

hello,
Can anyone help me:
i want to disable a database trigger from the form , how????
Thanks.

Report message to a moderator

Re: disable a database trigger from the form [message #277210 is a reply to message #277207]

Mon, 29 October 2007 04:27

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Why would you want to do that? Are you trying to fool Oracle, insert/update "something" which shouldn't be done and then enable trigger back again?

If not, what is it, then? Perhaps there's a "legal" workaround which someone might suggest if you tell us the background of the problem.

If you insist on executing DDL from Forms, well, there's no direct way to do it, but you might search for FORMS_DDL built-in.

Report message to a moderator

Re: disable a database trigger from the form [message #277392 is a reply to message #277210]

Mon, 29 October 2007 22:08

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

You could 'host' a SQL script to 'disable' the trigger.

David

Report message to a moderator

Previous Topic:	How to create dynamic lov
Next Topic:	update and insert new records in a form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 06:21:30 CDT 2024