Sybase Stored Procedure and Triggers

What is the maximum nesting level of Stored Procedure and Triggers in Sybase?

mamtasahu
Profile Answers by mamtasahu Questions by mamtasahu
Nov 26th, 2009
4
9575

Showing Answers 1 - 4 of 4 Answers

priyata
Profile Answers by priyata

Dec 1st, 2009

Sybase allows a maximum of 16 levels of nesting for both Stored Procedures and Triggers.

NaveenJain2010
Profile Answers by NaveenJain2010

Dec 8th, 2010

You can aslo get the nesting level with help of @@nestlevel global var.

Tejas More
Profile Answers by Tejas More

Jul 7th, 2011

Max nesting level is 16

neo.sql
Profile Answers by neo.sql

Sep 10th, 2011

The default option for maximum nesting level is 16 however this is a server configurable value and can be lesser than this also. To check the current maximum nesting level for stored procedures and triggers simply check the server configuration options using the system stored procedure - sp_configure and search for the configuration option - "nested level" and this will confirm if the actual maximum nesting level for the current server is - 16 or not.