Re: 260 crashes if no plan

Article View: borland.public.interbase.ibconsole

Article #61

Back to borland.public.interbase.ibconsole Previous Next

#61

From: Bill Todd
Date: Wed, 14 Nov 2007 20:42

13 lines
1530 bytes

Gelein van de Voorde wrote:

> First of all you don't need to include a "suspend" statement if you
> don't return any rows.

That is not correct. If the stored procedure has an output parameter
and you want the stored procedure to be selectable you must include
suspend. It makes no difference if the output parameter is filled with
a value from a column returned by SELECT or if it is filled with the
result of a calculation.

-- 
Bill Todd (TeamB)

Technical Details

Message-ID: <473b6bb7$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!club-internet.fr!feedme-small.clubint.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References:

<47376995@newsgroups.borland.com> <4738ccfb$1@newsgroups.borland.com> <473b5279@newsgroups.borland.com> <473b5eb1$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: f4565,d43ae017dafff62d
X-Google-Attributes: gidf4565,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Bill Todd" <no@no.com>
Subject: Re: 260 crashes if no plan
Newsgroups: borland.public.interbase.ibconsole
References: <47376995@newsgroups.borland.com> <4738ccfb$1@newsgroups.borland.com> <473b5279@newsgroups.borland.com> <473b5eb1$1@newsgroups.borland.com>
Organization: The Database Group, Inc.
User-Agent: XanaNews/1.18.1.6
X-Face: ":yn4zt^A_dn>6~{YJmu^B\'4w)e:apPM\VC=Dvf&*tASxX9|BYczkFd$xr.$vNSZ[3Uobr p]c4\+\l){!WQI.$]veP({HLd;CDYH?iN
NNTP-Posting-Host: 65.118.176.23
Message-ID: <473b6bb7$1@newsgroups.borland.com>
Date: 14 Nov 2007 13:42:15 -0700
X-Trace: newsgroups.borland.com 1195076535 65.118.176.23 (14 Nov 2007 13:42:15 -0700)
Lines: 13
X-Authenticated-User: btodd
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!club-internet.fr!feedme-small.clubint.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message