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 |
How would you lock a table in sybase? What text command will you use for it?
Explain 'forcing an index' concept.
We have lost the sa password, what can we do?
List the types of locking?
How do I set a password to be null?
How does sybase replication work?
What is the relationship between jdbc and sybase?
What is open server in sybase?
How to pad with leading zeros an int or smallint in sybase?
Can you create your own sps for system wise?
How do the blocker processes exist internally in sybase?
Sybase system databases