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.

Script to Procedure

2 posts in General Discussion Last posting was on 2005-08-10 15:07:40.0Z
Ivan Posted on 2005-08-09 17:15:01.0Z
From: "Ivan" <ibmoreno@bol.com.br>
Newsgroups: ianywhere.public.general
Subject: Script to Procedure
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.3790.1830
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
X-RFC2646: Format=Flowed; Original
X-Original-NNTP-Posting-Host: 201.24.21.174
Message-ID: <42f8e493@forums-2-dub>
X-Original-Trace: 9 Aug 2005 10:14:59 -0700, 201.24.21.174
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 9 Aug 2005 10:15:00 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 9 Aug 2005 10:15:01 -0700
X-Trace: forums-1-dub 1123607701 10.22.108.75 (9 Aug 2005 10:15:01 -0700)
X-Original-Trace: 9 Aug 2005 10:15:01 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4678
Article PK: 17359

Hi,

I am creating a modernization script in the Bank for a customer, in that
script there is two procedure that count a CURSOR with the same name, the
problem is when he rotates that script when passing in the second command
instruction SQL of the other procedure that count CUROS with the same name,
he/she gives mistake of CURSOR it already exists.

There is as I kill that cursor so that that doesn't happen, I already tried
CLOSE CURSOR and it doesn't solve.

Thank you

Ivan


Greg Fenton Posted on 2005-08-10 15:07:40.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla Thunderbird 1.6.3.2f (Windows/20050317)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Script to Procedure
References: <42f8e493@forums-2-dub>
In-Reply-To: <42f8e493@forums-2-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: gfenton-t30.sybase.com
X-Original-NNTP-Posting-Host: gfenton-t30.sybase.com
Message-ID: <42fa183c@forums-1-dub>
Date: 10 Aug 2005 08:07:40 -0700
X-Trace: forums-1-dub 1123686460 10.25.98.243 (10 Aug 2005 08:07:40 -0700)
X-Original-Trace: 10 Aug 2005 08:07:40 -0700, gfenton-t30.sybase.com
Lines: 25
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4680
Article PK: 8482


Ivan wrote:
>
> I am creating a modernization script in the Bank for a customer, in that
> script there is two procedure that count a CURSOR with the same name, the
> problem is when he rotates that script when passing in the second command
> instruction SQL of the other procedure that count CUROS with the same name,
> he/she gives mistake of CURSOR it already exists.
>
> There is as I kill that cursor so that that doesn't happen, I already tried
> CLOSE CURSOR and it doesn't solve.

Please, always post the version and build number of ASA that you are
using (e.g. use the command "dbeng9 -v" for SQLAnywhere 9.x).

Can you show us some code that is giving you the problem?
Can you describe the development environment you are using?

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/