Re: Simple Stored Procedure Problem

Article View: borland.public.interbase.sql

Article #278

Back to borland.public.interbase.sql Previous Next

#278

From: Jan Henrik Sylvester
Date: Sun, 17 Mar 2002 17:13

33 lines
1935 bytes

"Helmut W�ss" <h.woess@iis-edv.at> schrieb im Newsbeitrag
news:3c944d23$1_1@dnews...
> you forgot to put the result into the ouput variable!
> must be:
> SELECT count(*) FROM Banners into :a_value;
>
> bye,
> helmut
>
> "Ryan Born" <ryanborn@uiuc.edu> schrieb im Newsbeitrag
> news:3c93cc5f$1_2@dnews...
> > After an accidental post on my last one, here is my real problem!
> >
> > I have this Attempt to create a SP, but it won't work.
> > ------------------------------------------------------------
> > SET TERM !!;
> >
> > CREATE PROCEDURE my_procedure
> > RETURNS (a_value INTEGER)
> > AS
> > BEGIN
> >
> > SELECT count(*) FROM Banners;
> >
> > END !!
> >
> > SET TERM ;!!

In addition to Helmut W�ss reply, don't forget the "SUSPEND;" if you want
any return value...

HTH,
Jan Henrik Sylvester <me@janh.de>

Technical Details

Message-ID: <3c94ceb1_1@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!supernews.com!newsfeed.gamma.ru!Gamma.RU!news.maxwell.syr.edu!newsfeed.frii.com!out.nntp.be!propagator-SanJose!in.nntp.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

References: <3c93cc5f$1_2@dnews> <3c944d23$1_1@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: fd38c,3f0dbf6d00b0f337
X-Google-Attributes: gidfd38c,public
X-Google-Thread: 114a0e,3f0dbf6d00b0f337
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-03-17 09:23:16 PST
User-Agent: Hamster/1.3.23.130
From: "Jan Henrik Sylvester" <me@janh.de>
Newsgroups: borland.public.interbase.sql,borland.public.interbase.general
References: <3c93cc5f$1_2@dnews> <3c944d23$1_1@dnews>
Subject: Re: Simple Stored Procedure Problem
Date: Sun, 17 Mar 2002 18:13:25 +0100
Lines: 36
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: 217.184.181.212
Message-ID: <3c94ceb1_1@dnews>
X-Trace: dnews 1016385201 217.184.181.212 (17 Mar 2002 09:13:21 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!supernews.com!newsfeed.gamma.ru!Gamma.RU!news.maxwell.syr.edu!newsfeed.frii.com!out.nntp.be!propagator-SanJose!in.nntp.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

Reply to Parent Message