S.Proc

Article View: borland.public.interbase.sql

Article #619

Back to borland.public.interbase.sql Previous Next

#619

From: Serra
Date: Sat, 01 Sep 2007 13:09

27 lines
1370 bytes

IB 6,02

I created below s.proc in IbConsole without any error message
but when i try to call this proc ( select * from test (10)
i get below err. message
Error=Aritmetic Exception, Numeric Owerflow or
String Truncation....

What is wrong ?

CREATE  PROCEDURE  TEST (QTY SMALLINT)
RETURNS (
RNO INTEGER,
ODATE  DATE,
CUSTNAME  VARCHAR(40),
TOTAL NUMERIC (15,2))
AS
BEGIN
FOR SELECT  F.RNO, F.ODATE, F.TOTAL, C.CUSTNAME  FROM FLUGA F
JOIN CUSTOMER C ON  C.CUSTNO=F.CUSTNO
WHERE  F.ODATE > (SELECT MAX(DATE) FROM FLUGA) - : QTY
INTO :RNO,:ODATE,CUSTNAME,:TOTAL
DO
SUSPEND;
END

Thank you.

Technical Details

Message-ID: <46d964bd$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,821297de622fe5b0,start
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Serra" <no@no.com>
Newsgroups: borland.public.interbase.sql
Subject: S.Proc
Date: Sat, 1 Sep 2007 16:09:55 +0300
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.3138
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 85.107.5.153
Message-ID: <46d964bd$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1188652221 85.107.5.153 (1 Sep 2007 06:10:21 -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