🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.interbase.sql
Article #656

Error creating Stored Procedure in Interbase 2007

#656
From: Bob
Date: Thu, 25 Oct 2007 00:31
38 lines
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-mail

Show 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