Back to OIM Explorer

dbo.ATT_RAttestationHelperFill

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 1.144 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 source dbo.QBM_PSlotResetWhileJobRun_L source text reference

References

Referenced By

Complete Source

SQL52 lines
1CREATE PROCEDURE ATT_RAttestationHelperFill(2  @SlotNumber int3)4AS5BEGIN6  DECLARE @ObjectKeysToCheck_Projection QBM_YParameterList7  DECLARE @ObjectKeysToCheck_Jobrunning QBM_YParameterList8  DECLARE @MyName nvarchar(64) = object_name(@@procid)9  DECLARE @DBQueueCurrent QBM_YDBQueueCurrent10  DECLARE @resetted int11  SET XACT_ABORT OFF12  BEGIN TRY13    INSERT INTO @DBQueueCurrent(UID_DialogDBQueue,14    UID_Parameter,15    UID_SubParameter,16    GenProcID)17    SELECT18      UID_DialogDBQueue,19      UID_Parameter,20      UID_SubParameter,21      GenProcID22    FROM QBMDBQueueCurrent cu23      WITH(readpast)24    WHERE25      cu.SlotNumber = @SlotNumber26    IF @@rowcount = 027    BEGIN28      GOTO EndLabel29    END30    INSERT INTO @ObjectKeysToCheck_Jobrunning(Parameter1,31    Parameter2)32    SELECT33      x.UID_AttestationCase,34      x.XObjectKey35    FROM @DBQueueCurrent cu36    JOIN AttestationCase x37      ON cu.UID_Parameter = x.UID_AttestationCase38    EXEC @resetted = QBM_PSlotResetWhileJobRun_L @DBQueueCurrent,39      @@PROCID,40      @ObjectKeysToCheck_Jobrunning,41      @SlotNumber = @SlotNumber42  END TRY43  BEGIN CATCH44    EXEC QBM_PSessionErrorAdd DEFAULT45    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()46    RAISERROR(@Rethrow,47    18,48    1)49      WITH NOWAIT50  END CATCH51  endLabel:52END
Open raw exported source
SQL ยท Raw9 lines
1create   procedure ATT_RAttestationHelperFill (@SlotNumber int) AS begin declare @ObjectKeysToCheck_Projection QBM_YParameterList declare @ObjectKeysToCheck_Jobrunning2 QBM_YParameterList declare @MyName nvarchar(64) = object_name(@@procid) declare @DBQueueCurrent QBM_YDBQueueCurrent declare @resetted int SET XACT_ABORT3 OFF BEGIN TRY insert into @DBQueueCurrent(UID_DialogDBQueue, UID_Parameter, UID_SubParameter, GenProcID) select UID_DialogDBQueue, UID_Parameter, UID_SubParameter4, GenProcID from QBMDBQueueCurrent cu with (readpast) where cu.SlotNumber = @SlotNumber if @@rowcount = 0 begin goto EndLabel end  insert into @ObjectKeysToCheck_Jobrunning5(Parameter1, Parameter2) select x.UID_AttestationCase, x.XObjectKey from @DBQueueCurrent cu join AttestationCase x on cu.UID_Parameter = x.UID_AttestationCase6 exec @resetted = QBM_PSlotResetWhileJobRun_L @DBQueueCurrent, @@PROCID, @ObjectKeysToCheck_Jobrunning, @SlotNumber = @SlotNumber  END TRY BEGIN CATCH 7exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH endLabel:8 end 9