Subject Re: [firebird-support] Problem with STORED PROCEDURE and TRIGGER
Author Helen Borrie
At 11:47 AM 22/09/2003 +0200, you wrote:
>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.

What would like help with?