At 08:46 PM 1/17/2004, Robert Tulloch wrote:

>When trying to create stored procedure, I get:
>
>Error at line 2
>unsuccessful metadata update
>STORE RDB$PROCEDURE_PARAMETERS failed
>attempt to store duplicate value (visible to active transactions) in
>unique index "RDB$INDEX_18"
>SQL - CREATE PROCEDURE GETTENANTDATALIST(DATEENTRY DATE, DATEUP DATE)

OK. The first thing I would do is figure out what table and
field RDB$INDEX_18 references. Something like:

select i.rdb$relation_name, ii.rdb$field_name
from rdb$indices i join rdb$index_fields ii
on (i.rdb$index_name = ii.rdb$index_name);

Then I would use that information to query the same tables
looking for the duplicates.

Regards,


Ann