Hi Breton,

It should work. That message should be from your client application.

I have done this:

create table online_ ( timeout timestamp );
commit;

SET TERM ##;
CREATE PROCEDURE SET_TIMEOUT
AS
begin
update online_ set timeout = current_timestamp;
end ##
SET TERM ; ##
commit;

/*Populate*/
insert into online_ (timeout) values (current_timestamp);
commit;

execute procedure SET_TIMEOUT;
commit;

It worked ok, no errors at all.

Artur

----- Original Message -----
From: "brets1001" <korgal@...>
To: <ib-support@yahoogroups.com>
Sent: Monday, August 26, 2002 4:45 PM
Subject: [ib-support] problem with very simple Stored Procedure


> 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
>