I am sorry. I made a mistake! i use the software Interbase Query, a
freeware administrative tool. i don't use the IB_Query component. I
code directly through a SQL Editor.

--- In ib-support@y..., "Artur Anjos" <arsoft@n...> wrote:
>
> Ops, if you use a Query component you must use SUSPEND at the end
of your
> procedure. You must find a specific component in your tools of
components to
> execute with 'EXECUTE PROCEDURE'
>
> Artur
>
>
> ----- Original Message -----
> From: "brets1001" <korgal@h...>
> To: <ib-support@y...>
> Sent: Tuesday, August 27, 2002 7:38 PM
> Subject: [ib-support] Re: problem with very simple Stored Procedure
>
>
> >
> > Ok, i tried this code, suggested by helebor:
> >
> > > SET TERM ^;
> > > CREATE PROCEDURE SET_TIMEOUT
> > > AS
> > > begin
> > > update online_ set timeout = current_timestamp;
> > > end ^
> > >
> > > SET TERM ; ^
> >
> > but still, the same error message appears to me:
> >
> > > Statement #1:
> > > Unknown error.
> >
> > What i realised today is that I AM UNABLE to run any procedure
using
> > EXECUTE PROCEDURE.
> >
> > If i add a return value and i run the procedure through a SELECT
> > query (i.e. SELECT * FROM SET_TIMEOUT), the procedure runs fine.
But
> > using EXECUTE PROCEDURE only produces an error message.
> >
> > I use IB Query to code my procedures, i am not sure what type of
SQL
> > it uses (iSQL, dSQL, xxxSQL...). I have used this software for a
> > while, but always to create procedure called by SELECT queries.
> >
> > Maybe it's IB Query which is the problem. What are other good
> > software for programming firebird?
> >
> > Thank you
> >
> > S. Breton
> >