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.

SP with dynamic statement returns NULL as return value in ASE 12.0

2 posts in General Discussion Last posting was on 2006-08-24 14:38:53.0Z
Luis Porras Posted on 2006-08-24 14:35:00.0Z
From: "Luis Porras" <luis.porras@dakotaimaging.com>
Newsgroups: ianywhere.public.general
Subject: SP with dynamic statement returns NULL as return value in ASE 12.0
Lines: 17
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1807
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1807
X-Original-NNTP-Posting-Host: 200.91.73.205
Message-ID: <44edb698$1@forums-2-dub>
X-Original-Trace: 24 Aug 2006 07:24:24 -0700, 200.91.73.205
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 24 Aug 2006 07:24:26 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 24 Aug 2006 07:35:00 -0700
X-Trace: forums-1-dub 1156430100 10.22.108.75 (24 Aug 2006 07:35:00 -0700)
X-Original-Trace: 24 Aug 2006 07:35:00 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5584
Article PK: 1612

Hi,

I have a customer environment ASE 12.0 (no patches, the customer doesn't
want them...) on AIX 5.x. We are using ColdFusion (MX 6.1 over Windows) as
WebServer, one of the reports calls an sp using cfstoredproc function and
with the result set the cfstoredproc must catch the return status of the SP.
The problem is that the SP has a dynamic statement (is completely
neccesary), so the CF is catching the result set of the execute immediate
statement (as NULL) instead of the final return status of the SP (which is
0) so when the CF code evaluates this return status is not displaying
anything.

Thanks!!

~Luis


Greg Fenton Posted on 2006-08-24 14:38:53.0Z
From: Greg Fenton <greg.fenton@googles-mail-site>
User-Agent: Thunderbird 1.5.0.5 (Windows/20060719)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: SP with dynamic statement returns NULL as return value in ASE 12.0
References: <44edb698$1@forums-2-dub>
In-Reply-To: <44edb698$1@forums-2-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: wsp04839139wss.cr.net.cable.rogers.com
Message-ID: <44edb781@forums-2-dub>
X-Original-Trace: 24 Aug 2006 07:28:17 -0700, wsp04839139wss.cr.net.cable.rogers.com
Lines: 13
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 24 Aug 2006 07:28:19 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 24 Aug 2006 07:38:53 -0700
X-Trace: forums-1-dub 1156430333 10.22.108.75 (24 Aug 2006 07:38:53 -0700)
X-Original-Trace: 24 Aug 2006 07:38:53 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5585
Article PK: 1613


Luis Porras wrote:
>
> I have a customer environment ASE 12.0 (no patches, the customer doesn't
> want them...) on AIX 5.x.

Please post to one of the ASE newsgroups such as:

sybase.public.ase.general

g.f
--
Greg Fenton
Some Random Dude