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.

Change maximum stored procedure nesting level

2 posts in Internet Last posting was on 2000-01-04 22:33:16.0Z
Thomas Tsang Posted on 2000-01-04 05:07:12.0Z
Message-ID: <38718000.18F34D29@hkc.net>
Date: Tue, 04 Jan 2000 13:07:12 +0800
From: Thomas Tsang <thomast@hkc.net>
Organization: Hong Kong Communications Computer Ltd. Co.
X-Mailer: Mozilla 4.5 [en]C-CCK-MCD (Win98; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Change maximum stored procedure nesting level
Content-Type: multipart/mixed; boundary="------------9CABC23887D727285D609441"
Newsgroups: sybase.public.sqlserver.internet
Lines: 31
NNTP-Posting-Host: 202.146.123.120
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.internet:379
Article PK: 1067438

Hi all,

Currently I run a stored procedure in Sybase v11, this stored
procedure will recall itself when necessary, but when it procedure loop
16 times, the following message displayed:

Maximum stored procedure nesting level exceeded (limited 16)

Would anyone tell me how to change this configuration?

Thank you.


Thomas


Download VCard thomast.vcf


David Owen Posted on 2000-01-04 22:33:16.0Z
Sender: dowen@kashka.midsomer.org
Subject: Re: Change maximum stored procedure nesting level
References: <38718000.18F34D29@hkc.net>
From: David Owen <dowen@midsomer.org>
Organization: Midsomer Consultants Inc.
Date: 04 Jan 2000 15:33:16 -0700
Message-ID: <m23dsdo4b7.fsf@kashka.midsomer.org>
Lines: 17
User-Agent: Gnus/5.0802 (Gnus v5.8.2) Emacs/20.3
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Newsgroups: sybase.public.sqlserver.internet
NNTP-Posting-Host: 24.64.81.183.ab.wave.home.com 24.64.81.183
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.internet:378
Article PK: 1067436

>>>>> "Thomas" == Thomas Tsang <thomast@hkc.net> writes:

Thomas> Hi all, Currently I run a stored procedure in Sybase v11,
Thomas> this stored procedure will recall itself when necessary,
Thomas> but when it procedure loop 16 times, the following message
Thomas> displayed:

Thomas> Maximum stored procedure nesting level exceeded
Thomas> (limited 16)

Thomas> Would anyone tell me how to change this configuration?

This is a fixed limit, it cannot be increased. You will need
to rewrite the stored procedure.

--
David Owen Midsomer Consultants Inc. dowen@midsomer.org