Article View: borland.public.interbase.sql
Article #656Error creating Stored Procedure in Interbase 2007
From: Bob
Date: Thu, 25 Oct 2007 00:31
Date: Thu, 25 Oct 2007 00:31
38 lines
1797 bytes
1797 bytes
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.
Technical Details
Message-ID:
<471fe3e2$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,1c87e8aa4480bde1,start X-Google-Attributes: gid114a0e,public,usenet X-Google-Language: ENGLISH,ASCII-7-bit From: "Bob" <Bob@Bob.com> Newsgroups: borland.public.interbase.sql Subject: Error creating Stored Procedure in Interbase 2007 Date: Thu, 25 Oct 2007 10:31:31 +1000 Lines: 40 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.3138 X-RFC2646: Format=Flowed; Original X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198 NNTP-Posting-Host: 60.241.105.52 Message-ID: <471fe3e2$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1193272290 60.241.105.52 (24 Oct 2007 17:31:30 -0700) Path: arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail