Back to OIM Explorer

dbo.QBM_ZSetRowLockOnly

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 584 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_PDBQueueCurrentResetNGen source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.QBM_PSetRowLockOnly source text reference

References

Referenced By

Complete Source

SQL34 lines
1CREATE PROCEDURE QBM_ZSetRowLockOnly(2  @SlotNumberDummy int,3  @dummy1 varchar(38),4  @dummy2 varchar(38),5  @dummyGenProcID varchar(38)6)7AS8BEGIN9  DECLARE @ResetMessage nvarchar(4000)10  SET XACT_ABORT OFF11  BEGIN TRY12    BEGIN TRY13      EXEC QBM_PSetRowLockOnly '%'14    END TRY15    BEGIN CATCH16      EXEC QBM_PSessionErrorAdd DEFAULT17      SELECT @ResetMessage = ERROR_MESSAGE()18      IF @@TRANCOUNT > 019      BEGIN20        ROLLBACK21      END22      EXEC QBM_PDBQueueCurrentResetNGen @SlotNumberDummy,23        @ResetMessage,24        @@PROCID25    END CATCH26  END TRY27  BEGIN CATCH28    EXEC QBM_PSessionErrorAdd DEFAULT29    RAISERROR('',30    18,31    1)32      WITH NOWAIT33  END CATCH34END
Open raw exported source
SQL ยท Raw5 lines
1  create   procedure QBM_ZSetRowLockOnly (@SlotNumberDummy int , @dummy1 varchar(38) , @dummy2 varchar(38) , @dummyGenProcID varchar(38) ) as begin2  declare @ResetMessage nvarchar(4000) SET XACT_ABORT OFF BEGIN TRY BEGIN TRY exec QBM_PSetRowLockOnly '%' END TRY BEGIN CATCH exec QBM_PSessionErrorAdd3 default select @ResetMessage = ERROR_MESSAGE() if @@TRANCOUNT > 0 begin rollback end  exec QBM_PDBQueueCurrentResetNGen @SlotNumberDummy , @ResetMessage4 , @@PROCID END CATCH END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end 5