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: 21148
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: Surges Bay TAS Australia
Senior Member
Account Moderator
You could 'host' a SQL script to 'disable' the trigger.

David
Previous Topic: Show a tab Page
Next Topic: how to know which record or records are changed in a form
Goto Forum:
  


Current Time: Wed Aug 23 08:57:44 CDT 2017

Total time taken to generate the page: 0.04780 seconds