Cursors and isolation levels  Triggers and isolation levels

Chapter 20: Transactions: Maintaining Data Consistency and Recovery

Stored procedures and isolation levels

The Sybase system procedures always operate at isolation level 1, regardless of the isolation level of the transaction or session. User stored procedures operate at the isolation level of the transaction that executes it. If the isolation level changes within a stored procedure, the new isolation level remains in effect only during the execution of the stored procedure.





Copyright © 2005. Sybase Inc. All rights reserved. Triggers and isolation levels

View this book as PDF