need help with stored procedure

Article View: borland.public.interbase.sql

Article #752

Back to borland.public.interbase.sql Previous Next

#752

From: Roy
Date: Tue, 26 Jun 2007 07:51

53 lines
1924 bytes

i have this stored procedure but when i try to execute it in Delphi i get 
the error
invalid request BLR at offset 33
parameter mismatch for procedure MAX_TRAFFIC. The following is the code for 
the procedure

COMMIT WORK;
SET AUTODDL OFF;
SET TERM ^ ;

/* Stored procedures */

CREATE PROCEDURE "MAX_TRAFFIC"
(
  "ADATE" DATE,
  "A_GROUP" FLOAT,
  "AMSC_NAME" CHAR(10)
)
RETURNS
(
  "ATRAFFIC" FLOAT,
  "GROUP_NO" FLOAT,
  "MSC" VARCHAR(10)
)
AS
BEGIN EXIT; END ^


ALTER PROCEDURE "MAX_TRAFFIC"
(
  "ADATE" DATE,
  "A_GROUP" FLOAT,
  "AMSC_NAME" CHAR(10)
)
RETURNS
(
  "ATRAFFIC" FLOAT,
  "GROUP_NO" FLOAT,
  "MSC" VARCHAR(10)
)
AS
begin
 Select MSC_NAME, GROUP_, max(TRAFFIC) from SysGrpPerf where
 START_DATE = :"ADATE" and MSC_NAME = :"AMSC_NAME" and
 GROUP_ = :"A_GROUP" and  Start_Time between '00:00' and '23:00'
 GROUP BY MSC_NAME, GROUP_
 INTO : MSC,:"GROUP_NO", :aTRAFFIC;
end
 ^

SET TERM ; ^
COMMIT WORK;
SET AUTODDL ON;

Technical Details

Message-ID: <4680c695@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!feeder3.cambrium.nl!feeder2.cambrium.nl!feed.tweaknews.nl!193.201.147.84.MISMATCH!xlned.com!feeder1.xlned.com!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,220d4992ac1e09be,start
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Roy" <butcherr@candw.lc>
Newsgroups: borland.public.interbase.sql
Subject: need help with stored procedure
Date: Tue, 26 Jun 2007 02:51:58 -0500
Lines: 55
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.3138
NNTP-Posting-Host: 200.2.131.50
Message-ID: <4680c695@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1182844565 200.2.131.50 (26 Jun 2007 00:56:05 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!feeder3.cambrium.nl!feeder2.cambrium.nl!feed.tweaknews.nl!193.201.147.84.MISMATCH!xlned.com!feeder1.xlned.com!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail