Back to OIM Explorer

dbo.QBM_PJobQueueDelete_Single

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 531 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_PJobQueueDelete source text reference
  • references source dbo.QBM_PJobQueueDelete_Bulk source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL24 lines
1CREATE PROCEDURE QBM_PJobQueueDelete_Single(2  @UID_Tree varchar(38)3)4AS5BEGIN6  DECLARE @TreesToDelete QBM_YParameterList7  DECLARE @AnzahlLoeschGesamt int8  SET XACT_ABORT OFF9  BEGIN TRY10    INSERT INTO @TreesToDelete(Parameter1)11    VALUES(@UID_Tree)12    EXEC @AnzahlLoeschGesamt = QBM_PJobQueueDelete_Bulk @TreesToDelete13  END TRY14  BEGIN CATCH15    EXEC QBM_PSessionErrorAdd DEFAULT16    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()17    RAISERROR(@Rethrow,18    18,19    1)20      WITH NOWAIT21  END CATCH22  endLabel:23  RETURN(@AnzahlLoeschGesamt)24END
Open raw exported source
SQL ยท Raw5 lines
1  create   procedure QBM_PJobQueueDelete_Single (@UID_Tree varchar(38) ) as begin declare @TreesToDelete QBM_YParameterList declare @AnzahlLoeschGesamt2 int SET XACT_ABORT OFF BEGIN TRY insert into @TreesToDelete(Parameter1) values (@UID_Tree) exec @AnzahlLoeschGesamt = QBM_PJobQueueDelete_Bulk @TreesToDelete3 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH4 NOWAIT END CATCH endLabel: return (@AnzahlLoeschGesamt) end 5