Re: Error creating Stored Procedure in Interbase 2007

Article View: borland.public.interbase.sql

Article #662

Back to borland.public.interbase.sql Previous Next

#662

From: Bob
Date: Thu, 25 Oct 2007 03:12

28 lines
1589 bytes

RDB$INDEX_18 refers to

table:

RDB$PROCEDURE_PARAMETERS

looking for any reference to my procedure in here.

PROC_EXT_MYTABLE

It does not exist.

I think it is locked away in some transaction I cannot see.

Kind Regards,

Robert.

"Zoren Lendry" <zorenlendry@yahoo.com> wrote in message 
news:471ffca1$1@newsgroups.borland.com...
> Bob wrote:
>> attempt to store duplicate value (visible to active transactions) in 
>> unique index "RDB$INDEX_18"
>
> the duplicate value is the name of the procedure, which was inserted into 
> the system tables, in spite of the fact that the whole operation hung.
>
> Loren

Technical Details

Message-ID: <472009b9$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!proxad.net!feeder1-2.proxad.net!62.111.101.3.MISMATCH!news.germany.com!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <471fe3e2$1@newsgroups.borland.com> <471ffca1$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,1c87e8aa4480bde1
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Bob" <Bob@Bob.com>
Newsgroups: borland.public.interbase.sql
References: <471fe3e2$1@newsgroups.borland.com> <471ffca1$1@newsgroups.borland.com>
Subject: Re: Error creating Stored Procedure in Interbase 2007
Date: Thu, 25 Oct 2007 13:12:58 +1000
Lines: 30
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 60.241.105.52
Message-ID: <472009b9$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1193281977 60.241.105.52 (24 Oct 2007 20:12:57 -0700)
Path: arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!proxad.net!feeder1-2.proxad.net!62.111.101.3.MISMATCH!news.germany.com!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message