RE: getting recursive error, any ideas?

2001-06-13 Thread Naik, Sandesh S
Thanks Ian, I dropped the trigger and that solved the problem. I will test it on some other test database. Your work is good. Sandesh -Original Message- Sent: Tuesday, June 12, 2001 6:51 PM To: Multiple recipients of list ORACLE-L It's due to a trigger. Unfortunately it looks very s

RE: getting recursive error, any ideas?

2001-06-12 Thread MacGregor, Ian A.
It's due to a trigger. Unfortunately it looks very similar to the error I was getting on the trigger which recorded destructive DDL. The corrected trigger code has been sent in another mail; a close cursor statment was placed incorrectly in the code. Your statement is failing because the pr