Why is that not possible? Is there a trick or something like that?

-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: Mon 22.09.2003 11:54
To: firebird-support@yahoogroups.com
Cc:
Subject: Re: [firebird-support] Problem with STORED PROCEDURE and TRIGGER



At 11:47 AM 22/09/2003 +0200, you wrote:

>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?

Yes.

>
>Please help. Thank you very much in advance.

What would like help with?

heLen



------------------------ Yahoo! Groups Sponsor ---------------------~-->
Upgrade to 128-Bit SSL Security!
http://us.click.yahoo.com/p7cEmB/s7qGAA/yigFAA/67folB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/






[Non-text portions of this message have been removed]