Re: 260 crashes if no plan

Article View: borland.public.interbase.ibconsole

Article #59

Back to borland.public.interbase.ibconsole Previous Next

#59

From: Brent Rose
Date: Wed, 14 Nov 2007 19:54

30 lines
1859 bytes

A selectable s/proc that does not access any tables and therefore does not 
involve any "PLAN" will cause IBConsole to spit the dummy. (Maybe it is not 
really related to having no-PLAN per se, but I have always had the 
impression in the past that this was, in actual fact, the general reason).

NB My s/proc in this case just performs a complex calculation without 
needing to retrieve any data from tables per se. (I could make this a UDF 
instead at some point...)

Example:

create procedure SpitTheDummy
returns(
    MyResult Integer)
as
begin
    MyResult = 0;
    suspend;
end;

"select * from SpitTheDummy" will cause IBConsole to crash.... (but executes 
fine when used in my app).

Dropping the "suspend" and using "execute procedure SpitTheDummy" seems to 
work OK, however.

-- 
Brent Rose
Whats On Report
brent@whatson.co.nz

Technical Details

Message-ID: <473b5279@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>

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: "Brent Rose" <brent@whatson.co.nz>
Newsgroups: borland.public.interbase.ibconsole
References:  <47376995@newsgroups.borland.com> <4738ccfb$1@newsgroups.borland.com>
Subject: Re: 260 crashes if no plan
Date: Thu, 15 Nov 2007 08:54:53 +1300
Lines: 32
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: 203.79.66.167
Message-ID: <473b5279@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1195070073 203.79.66.167 (14 Nov 2007 11:54:33 -0700)
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