Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

store procedure & jaguar

3 posts in General Discussion (old) Last posting was on 2000-02-27 20:19:36.0Z
john Posted on 2000-02-27 10:15:48.0Z
Newsgroups: sybase.public.easerver
Reply-To: "john" <wujun@990.net>
From: "john" <wujun@990.net>
Subject: store procedure & jaguar
Date: Sun, 27 Feb 2000 18:15:48 +0800
Lines: 17
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2014.211
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211
NNTP-Posting-Host: 202.102.97.48
Message-ID: <347_8i4WswQg$GA.202@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:27721
Article PK: 159080

hi,everyone.

i use a datawindow (get data from a store porcedure) in my web page. in the
procedure ,
the following command is used:
select * into #table_tmp from tabel_a

then i get this error:

ERROR: Retrieve Failed = -1 *****
Select error: Requested result set number 1 not found
************************

what can i do ?
thanks in advances.


Jim O'Neil [Sybase] Posted on 2000-02-27 20:19:36.0Z
Newsgroups: sybase.public.easerver
Date: Sun, 27 Feb 2000 15:19:36 -0500
From: "Jim O'Neil [Sybase]" <joneil@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.7 [en]C-CCK-MCD (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: store procedure & jaguar
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 27
NNTP-Posting-Host: nomad6-33.sybase.com 157.133.176.33
Message-ID: <347_38B986D8.1BEB4EE0@sybase.com>
References: <347_8i4WswQg$GA.202@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:27710
Article PK: 159070


john wrote:

> hi,everyone.
>
> i use a datawindow (get data from a store porcedure) in my web page. in the
> procedure ,
> the following command is used:
> select * into #table_tmp from tabel_a
>
> then i get this error:
>
> ERROR: Retrieve Failed = -1 *****
> Select error: Requested result set number 1 not found
> ************************
>
> what can i do ?
> thanks in advances.

Are you using the WebDW with ASE? With the creation of a temporary table you
are actually trying to issue DDL within the scope of a transaction, because the
WebDW by default requires a transaction. That error is probably the core of
the problem with the result that the result set is never generated. As a quick
text, set the HTMLGenerator component to not support a transaction and see it
if works. If it does, then this is the problem you are running into and you'll
either need to leave the transaction setting as such or set your database up to
allow DDL in transactions.


Jim O'Neil
Senior Technical Support Engineer
Sybase, Inc


john Posted on 2000-02-27 10:28:44.0Z
Newsgroups: sybase.public.easerver
Reply-To: "john" <wujun@990.net>
From: "john" <wujun@990.net>
Subject: Re: store procedure & jaguar
Date: Sun, 27 Feb 2000 18:28:44 +0800
Lines: 3
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2014.211
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211
NNTP-Posting-Host: 202.102.97.48
Message-ID: <347_NLX463Qg$GA.202@forums.sybase.com>
References: <347_8i4WswQg$GA.202@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:27720
Article PK: 159081

i also create a index on the temp table .