Home » Developer & Programmer » Forms » disable a database trigger from the form
icon4.gif  disable a database trigger from the form [message #277207] Mon, 29 October 2007 04:20 Go to next message
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.
Re: disable a database trigger from the form [message #277210 is a reply to message #277207] Mon, 29 October 2007 04:27 Go to previous messageGo to next message
Littlefoot
Messages: 20888
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.
Re: disable a database trigger from the form [message #277392 is a reply to message #277210] Mon, 29 October 2007 22:08 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
You could 'host' a SQL script to 'disable' the trigger.

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


Current Time: Fri Dec 02 17:02:01 CST 2016

Total time taken to generate the page: 0.37256 seconds