🚀 go-pugleaf

It appears to me you have two variables of the same name. Here is a 
simple way to get almost exactly the same error:

create procedure foo (x int, x int) as
begin
x=1;
end;

RDB$INDEX_18 is an index on parameter names to a stored procedures. It 
is a unique index on parameters name and procedure name.


Bob wrote:
> I get the following Error, The Stored Procedure is not preexistant :
> 
> ISC ERROR CODE:335544351
> 
> ISC ERROR MESSAGE:
> unsuccessful metadata update
> STORE RDB$PROCEDURE_PARAMETERS failed
> lock conflict on no wait transaction
> attempt to store duplicate value (visible to active transactions) in unique 
> index "RDB$INDEX_18"
> 
> The procedure is as follows
> 
> CREATE PROCEDURE PROC_EXT_MYTABLE
> ( ROWS_PROCESSED_SO_FAR INTEGER, ROWS_PERCYCLE INTEGER )
> RETURNS
> ( BATCH_ROWS_PROCESSED INTEGER )
> AS
> DECLARE VARIABLE THESTOREID VARCHAR(10);
> DECLARE VARIABLE THESALESDATE TIMESTAMP;
> DECLARE VARIABLE THEPLU VARCHAR(14);
> DECLARE VARIABLE THEQUANTITYSOLD FLOAT;
> DECLARE VARIABLE THESALESEXGST FLOAT;
> DECLARE VARIABLE THECOSTEXGST FLOAT;
> DECLARE VARIABLE THESALESINCGST FLOAT;
> DECLARE VARIABLE THECOSTINCGST FLOAT;
> DECLARE VARIABLE THECOUNT INTEGER;
> BEGIN
>   DO SUMETHING;
>   BATCH_ROWS_PROCESSED = THECOUNT;
>   SUSPEND;
> END;
> 
> How can this possibly happen?
> 
> Kind Regards,
> 
> Robert.
> 
>