Martijn,

what do you mean by calling application?
i have to commit the procedure if it is succeed. if not, i need to rollback.
why can't i control this inside the procedure? why should be done by the
calling application?

thx!
Regina Phandu

----- Original Message -----
From: "Martijn Tonies" <m.tonies@...>
To: <ib-support@yahoogroups.com>
Sent: Friday, October 11, 2002 1:17 AM
Subject: Re: [ib-support] error in sp


> Hi,
>
> > i've created a store procedure.
> > the idea is to raise an error code/message to the user if the procedure
> > failed and to raise a message if the procedure succeed.
> > i've read the language reference manual, and it said that if used, WHEN
> must
> > be the last statement in the begin..end block.
> >
> > i guess i have to assign one variable. but how do this variable know
that
> > this procedure works well or not.
> > fyi, i need to rollback everything if there was an error, if not, then
> > commit.
>
> You cannot control transaction from within a stored procedure. All
> transaction
> control is done by the calling application.
>
>
> With regards,
>
> Martijn Tonies
> InterBase Workbench - the developer tool for InterBase
> http://www.upscene.com
>
> Firebird Workbench - the developer tool for Firebird
> http://www.upscene.com
>
> Upscene Productions
> http://www.upscene.com
>
> "This is an object-oriented system.
> If we change anything, the users object."
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>