What is the maximum nesting level of Stored Procedure and
Triggers in Sybase?
Answers were Sorted based on User's Feedback
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 |
Compare in and exists?
what is the difference between an ltm and a repagent in sybase?
How do I run multiple versions of sybase on the same server?
What is open client in sybase?
What is table partitioning in sybase?
How to take backup in sybase database in sap?
Explain the structure of adaptive server enterprise?
What is the difference between replication server and sql remote in sybase?
What are the different types of (all page) locks in sybase?
How do I open sybase control center?
How to connect sybase server with unix.
How do I start sybase control center in windows?