Subject | problem with very simple Stored Procedure |
---|---|
Author | brets1001 |
Post date | 2002-08-26T15:45:07Z |
Hi,
Here is my very simple SP:
CREATE PROCEDURE SET_TIMEOUT
AS
begin
update online_ set timeout = current_timestamp;
end
But Firebird 1.0 returns me this error:
Statement #1:
Unknown error.
I doublechecked table "online_" and column "timeout" datatype is
timestamp.
Thank you for your help
S. Breton
Here is my very simple SP:
CREATE PROCEDURE SET_TIMEOUT
AS
begin
update online_ set timeout = current_timestamp;
end
But Firebird 1.0 returns me this error:
Statement #1:
Unknown error.
I doublechecked table "online_" and column "timeout" datatype is
timestamp.
Thank you for your help
S. Breton