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@...>
To: <ib-support@yahoogroups.com>
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
>