Subject Re: [ib-support] problem with very simple Stored Procedure
Author Helen Borrie
At 03:45 PM 26-08-02 +0000, you wrote:
>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.

Is your DB Dialect 1?

If so, try

update online_ set timeout = cast('NOW' as date);

-- heLen