Home » Developer & Programmer » Forms » update trigger error
update trigger error [message #294234] Wed, 16 January 2008 23:04 Go to next message
Messages: 35
Registered: January 2008
When i tried to update any record the record has been updated but with the following message
Procedure Update_Record only allowed in an update Trigger
how can i disable this trigger
i have written update_recod statement when button pressed trigger
Re: update trigger error [message #294287 is a reply to message #294234] Thu, 17 January 2008 02:04 Go to previous message
Messages: 21148
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How do you update that record? Is it by overtyping current values in a database block? If so, you don't need a trigger at all - just COMMIT the changes.

If you are doing that in a trigger by issuing the
UPDATE some_table SET column = ...
I guess you should post code you use.

UPDATE_RECORD you mention is a restricted procedure and is valid ONLY in the ON-UPDATE trigger; it is included primarily for applications that run against non-Oracle data source.

So, would you mind to explain your problem a little bit more?
Previous Topic: webutil
Next Topic: message must move left continuously like ticker tape on TV screen like oracle
Goto Forum:

Current Time: Mon Aug 21 14:38:35 CDT 2017

Total time taken to generate the page: 0.05359 seconds