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

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

Question Posted / mamtasahu

2 Answers
13957 Views
L&T, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / rinu

Triggers can nest to a depth of 16 levels. The current
nesting level is stored in the @@nestlevel global variable.
Nesting is enabled at installation. A System Administrator
can turn trigger nesting on and off with the allow nested
triggers configuration parameter.
the same is applied for Sp with nesting level with a range
or depth from 0 to 16.
if more than 16 then we get an error as :Maximum stored
procedure nesting level exceeded (limit 16).

Is This Answer Correct ?

19 Yes

1 No

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

Answer / jayakumar

If more than 16 levels, it will degrade your performance.

Is This Answer Correct ?

0 Yes

2 No

Post New Answer