> I created a stored procedure, then I came back later to alter it and I
> an error every time. Logging out completely and even rebooting
> haven't fixed it, I have no idea what to do.
>
> Here's the error & stored procedure:
>
> ISC ERROR CODE:335544351
>
> ISC ERROR MESSAGE:
> unsuccessful metadata update
> STORE RDB$PROCEDURE_PARAMETERS failed
> attempt to store duplicate value (visible to active transactions) in
> unique index "RDB$INDEX_18"
>
> Statement: create procedure "sel_active_order_by_customer_id"
> (
> "user_id" varchar(50)
> )
> returns
> (
> "order_id" int,
> "user_id" varchar(50),
> "invoice_id" varchar(50),
> "order_date" date,
> "ship_date" date,
> "order_status" varchar(50),
> "payment_status" varchar(50),
> "shipping_amt" decimal,
> "tax_amt" decimal,
> "order_amt" decimal,
> "payment_message" varchar(100),
> "avs_code" varchar(50),
> "is_active" char(1)
> )

[snip]

You use "user_id" as input and output parameter.

You can't have equally named input/output parameters.

Btw, is there a special reason why you want to have
case-sensitive parameter/variable names?


Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions
http://www.upscene.com