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: 21068
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: uploading the file in database table
Next Topic: i cant compile menu
Goto Forum:

Current Time: Sun Apr 30 15:50:45 CDT 2017

Total time taken to generate the page: 0.09766 seconds