Back to OIM Explorer

dbo.QBM_PDBQCS_SlotReset

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 737 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_FGIDBQueueSlotResetType source text reference
  • references source dbo.QBM_FGISessionErrorRethrow source text reference
  • references source dbo.QBM_PDBQCS_CurrentMoveSlot source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL32 lines
1CREATE PROCEDURE QBM_PDBQCS_SlotReset(2  @SlotNumberCrashed int3)4AS5BEGIN6  DECLARE @ret int = 07  DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()8  DECLARE @SlotNumberTarget int = dbo.QBM_FGIDBQueueSlotResetType('Error04')9  DECLARE @DBQueueToMove QBM_YDBQCSCurrentToMove10  DECLARE @RowsMoved int11  SET XACT_ABORT OFF12  BEGIN TRY13    INSERT INTO @DBQueueToMove(UID_DialogDBQueue)14    SELECT cul.UID_DialogDBQueue15    FROM QBMDBQueueCurrent cul16      WITH(readpast)17    WHERE18      cul.SlotNumber = @SlotNumberCrashed19    EXEC @RowsMoved = QBM_PDBQCS_CurrentMoveSlot @DBQueueToMove,20      @SlotNumberCrashed,21      @SlotnumberTarget22  END TRY23  BEGIN CATCH24    EXEC QBM_PSessionErrorAdd DEFAULT25    RAISERROR(@Rethrow,26    18,27    1)28      WITH NOWAIT29  END CATCH30  endLabel:31  RETURN @ret32END
Open raw exported source
SQL ยท Raw6 lines
1   create   procedure QBM_PDBQCS_SlotReset (@SlotNumberCrashed int) as begin declare @ret int = 0 declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow2() declare @SlotNumberTarget int = dbo.QBM_FGIDBQueueSlotResetType('Error04') declare @DBQueueToMove QBM_YDBQCSCurrentToMove declare @RowsMoved int SET3 XACT_ABORT OFF BEGIN TRY insert into @DBQueueToMove(UID_DialogDBQueue) select cul.UID_DialogDBQueue from QBMDBQueueCurrent cul with (readpast) where cul.SlotNumber4 = @SlotNumberCrashed exec @RowsMoved = QBM_PDBQCS_CurrentMoveSlot @DBQueueToMove, @SlotNumberCrashed, @SlotnumberTarget END TRY BEGIN CATCH exec QBM_PSessionErrorAdd5 default RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH endLabel: return @ret end 6