Back to OIM Explorer

dbo.QBM_PDBQCS_AppLockSet

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 579 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

SQL31 lines
1CREATE PROCEDURE QBM_PDBQCS_AppLockSet2AS3BEGIN4  DECLARE @ret int = 05  DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()6  DECLARE @LockRC int7  SET XACT_ABORT OFF8  BEGIN TRY9    EXEC @LockRC = sp_getapplock @Resource = 'QBM_PDBQCS_Main',10      @LockMode = 'Exclusive',11      @LockOwner = 'Session',12      @LockTimeout = 1000,13      @DbPrincipal = 'public'14    IF @LockRC < 015    BEGIN16      RAISERROR('#LDS#Could not set application lock.|',17      18,18      1)19        WITH nowait20    END21  END TRY22  BEGIN CATCH23    EXEC QBM_PSessionErrorAdd DEFAULT24    RAISERROR(@Rethrow,25    18,26    1)27      WITH NOWAIT28  END CATCH29  endLabel:30  RETURN @ret31END
Open raw exported source
SQL ยท Raw5 lines
1 create   procedure QBM_PDBQCS_AppLockSet as begin declare @ret int = 0 declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() declare2 @LockRC int SET XACT_ABORT OFF BEGIN TRY exec @LockRC = sp_getapplock @Resource = 'QBM_PDBQCS_Main' , @LockMode = 'Exclusive' , @LockOwner = 'Session'3 , @LockTimeout = 1000 , @DbPrincipal = 'public' if @LockRC < 0 begin raiserror ('#LDS#Could not set application lock.|', 18, 1) with nowait end END TRY4 BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH endLabel: return @ret end 5