Back to OIM Explorer

dbo.QBM_PDBQCS_AppLockRelease

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 385 characters

Interpretation

  • Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.

Relations

  • No extracted relations.

Typed Edges

  • references source dbo.QBM_FGISessionErrorRethrow source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL20 lines
1CREATE PROCEDURE QBM_PDBQCS_AppLockRelease2AS3BEGIN4  DECLARE @ret int = 05  DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()6  SET XACT_ABORT OFF7  BEGIN TRY8    EXEC sp_releaseapplock @Resource = 'QBM_PDBQCS_Main',9      @LockOwner = 'Session'10  END TRY11  BEGIN CATCH12    EXEC QBM_PSessionErrorAdd DEFAULT13    RAISERROR(@Rethrow,14    18,15    1)16      WITH NOWAIT17  END CATCH18  endLabel:19  RETURN @ret20END
Open raw exported source
SQL ยท Raw4 lines
1 create   procedure QBM_PDBQCS_AppLockRelease as begin declare @ret int = 0 declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() SET2 XACT_ABORT OFF BEGIN TRY exec sp_releaseapplock @Resource = 'QBM_PDBQCS_Main' , @LockOwner = 'Session' END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default3 RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH endLabel: return @ret end 4