| update trigger error [message #294234] |
Wed, 16 January 2008 23:04  |
asadkhan_2
Messages: 36
Registered: January 2008
|
Member |
|
|
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
thanks
|
|
|
|
| Re: update trigger error [message #294287 is a reply to message #294234] |
Thu, 17 January 2008 02:04  |
 |
Littlefoot
Messages: 21826
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 = ...
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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
