Subject | Re: problem with very simple Stored Procedure |
---|---|
Author | brets1001 |
Post date | 2002-08-27T18:38:04Z |
Ok, i tried this code, suggested by helebor:
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
> SET TERM ^;but still, the same error message appears to me:
> CREATE PROCEDURE SET_TIMEOUT
> AS
> begin
> update online_ set timeout = current_timestamp;
> end ^
>
> SET TERM ; ^
> Statement #1:What i realised today is that I AM UNABLE to run any procedure using
> Unknown error.
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