Sybase @@nestlevel
Current stored procedure or trigger nesting level with a range or depth from 0 to 16.
| nesttest.sql |
|---|
if exists( select * from sysobjects where name = 'nesttest' and type = 'P' ) drop procedure nesttest go
create procedure nesttest
as
if @@nestlevel = 1 select @@version
set nocount on
select @@nestlevel
exec nesttest
go
exec nesttest
go
if exists( select * from sysobjects where name = 'nesttest' and type = 'P' ) drop procedure nesttest go
go
|
| isql -S myServer -D myDatabase -U myUser -P myPass -b < nesttest.sql |
Adaptive Server Enterprise/11.9.2.6/1290/P/EBF 10491 ESD1/Sun_svr4/OS 5.5.1/FBO/
Mon Jul 15 06:54:22 2002
(1 row affected)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Msg 3626, Level 17, State 1:
Server 'myServer', Procedure 'nesttest', Line 4:
The transaction was aborted because it used too much stack space.
Either use sp_configure to increase the stack size, or break the query into smaller pieces.
spid: 42, suid: 1457, hostname: nys36a-0007, application name: isql (return status = 0)
|
| isql -S myServer -D myDatabase -U myUser -P myPass -b < nesttest.sql |
Adaptive Server Enterprise/12.5.3/EBF 12455 ESD#2/P/Sun_svr4/OS 5.8/ase1253/1904
/64-bit/FBO/Wed Mar 23 03:04:04 2005
(1 row affected)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
Msg 217, Level 16, State 1:
Server 'myServer', Procedure 'nesttest', Line 7:
Maximum stored procedure nesting level exceeded (limit 16).
(return status = -6)
|
|
Roger Hall COMPUSPEC |
|