At 12:11 PM 22/09/2003 +0200, you wrote:

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

It *is* possible. People do it all the time. But how can we look at what
is causing your error if you don't provide any details? The code that is
failing would be an appropriate place to start.

heLen

> -----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
>
> 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]
>
>
>
>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/