Re: Trigger referencing another table and calling SP
Thanks for the in depth explaination.
I was trying to lock the table in the trigger
was getting
ERROR 1100 (HY000): Table 'fund' was not locked with LOCK TABLES
ERROR 1314 (0A000): LOCK is not allowed in stored procedures
Subject
Views
Written By
Posted
4303
June 11, 2005 09:54AM
2996
June 12, 2005 08:41AM
2537
June 20, 2005 08:04PM
2576
June 21, 2005 01:43AM
2683
June 26, 2005 10:44PM
9841
June 27, 2005 01:01AM
Re: Trigger referencing another table and calling SP
2879
June 27, 2005 11:32PM
4350
July 28, 2005 09:35AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.