Hello ,

I tried to create the stored procedure:

CREATE PROCEDURE PRC_CLIENT_STATE (
NAME CHAR(50))
RETURNS (
TIMER INTEGER,
STATE CHAR(1))
AS
begin
if (not(exists(select wi.ws_id from wcs_info wi where wi.ws_name = :name))) then
begin
insert into wcs_info (ws_name, ws_active,updated)
values (:name, 'f', 'now');
end
STATE = 'w';
TIMER = 10;
end


But, when I try to call it from Delphi5 using IBO, I got a message
"Cannot find parameter STATE".

After changing "STATE" to "STATE1", procedure works good.

Is state a reserved word? In official list of Firebird reserved words
on www.ibphoenix.com it missing.

PS. IBO version 4A2, Firebird WI-T0.9.4.103

--
Best regards,
Vladimir Kozloff mailto:Kozloff@...