DB2 - L

 View Only
Back to discussions
Expand all | Collapse all

What happen to SET ISOLATION LEVEL in a stored procedure if the SP fails ?

  • 1.  What happen to SET ISOLATION LEVEL in a stored procedure if the SP fails ?

    Posted Sep 24, 2022 04:43 AM
    Dear all,
    forgive me if this question has been already answered in the forum.

    I am wriitng a SP in DB2 LUW V11.1 with SET ISOLATION LEVEL UR as a first statement and SET ISOLATION LEVEL RESET as last statement.

    What happen to the current isolation level is such SP fails in between ?
    Is it reset anyway to the caller ISOLATION LEVEL or remains UR until the connection is closed ?

    Thanks for your advice.



    ------------------------------
    MassimilianoCampagnoliPaolo Astori spa
    ------------------------------