Bob 1. Is the update working? 2. If not, what exactly is the command that is failing - can you post it here for us to look at? 3. Can you take the same code and run it from a stand alone file or R> prompt and does it work?
David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "Bob Taylor" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Tuesday, February 01, 2005 9:38 PM Subject: [RBG7-L] - After Update Trigger - Resources required by command are not available. I am trying to modify column values in response to inserts/updates. I am attempting to do this with AFTER INSERT and AFTER UPDATE table triggers. The triggers simply get the primary key value using sys_new and then execute an update statement back against the table using this value. I have the necessary checks and balances to prevent an endless loop of updates. The trigger works for inserts, and the expected column changes take place. However, for updates I am getting the error "Resources required by command are not available" when the update statement within the trigger fires. I believe the error code is 2110. It would seem that if the technique works for inserts that it should also work for updates. Can anyone shed some light on this? Thanks Bob
