| Subject | Problem with STORED PROCEDURE and TRIGGER |
|---|---|
| Author | Marc Geldon |
| Post date | 2003-09-22T09:47:08Z |
Hello!
I have 2 tables in my database. Let us call them "TABLE1" and "TABLE2". I have a AFTER INSERT trigger on Table 1 and this trigger calls a stored procedure which inserts a new row in table2.
But it does not work. If I insert something in TABLE1 I get the error message: -504 Cursor unknown.
Why that? Is it not possible to call a procedure which writes into another table in a trigger?
Please help. Thank you very much in advance.
Best wishes,
Marc Geldon
I have 2 tables in my database. Let us call them "TABLE1" and "TABLE2". I have a AFTER INSERT trigger on Table 1 and this trigger calls a stored procedure which inserts a new row in table2.
But it does not work. If I insert something in TABLE1 I get the error message: -504 Cursor unknown.
Why that? Is it not possible to call a procedure which writes into another table in a trigger?
Please help. Thank you very much in advance.
Best wishes,
Marc Geldon