Subject Problem with STORED PROCEDURE and TRIGGER
Author 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