Hi,

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

Input and output parameter have the same name.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com