Back to OIM Explorer

dbo.QBM_P40B0C8AE71E45BA9C883A96_

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 596 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_PDBQueueInsert_Int source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

Complete Source

SQL35 lines
1CREATE PROCEDURE QBM_P40B0C8AE71E45BA9C883A96_(2  @PondGroup varchar(38),3  @UID_Task varchar(38)4)5AS6BEGIN7  DECLARE @DBQueueElements QBM_YDBQueueRaw8  SET XACT_ABORT OFF9  BEGIN TRY10    INSERT INTO @DBQueueElements(Object,11    SubObject,12    GenProcID)13    SELECT14      t.Object,15      t.SubObject,16      t.GenProcID17    FROM QBMDBQueuePond t18    WHERE19      t.UID_Task = @UID_Task AND t.PondGroup = @PondGroup20    GROUP BY t.Object,21    t.SubObject,22    t.GenProcID23    EXEC QBM_PDBQueueInsert_Int @UID_Task,24      @DBQueueElements25  END TRY26  BEGIN CATCH27    EXEC QBM_PSessionErrorAdd DEFAULT28    RAISERROR('',29    18,30    1)31      WITH NOWAIT32  END CATCH33  endLabel:34  RETURN35END
Open raw exported source
SQL ยท Raw5 lines
1  create   procedure QBM_P40B0C8AE71E45BA9C883A96_( @PondGroup varchar(38) , @UID_Task varchar(38)    ) as begin declare @DBQueueElements QBM_YDBQueueRaw2 SET XACT_ABORT OFF BEGIN TRY insert into @DBQueueElements (Object, SubObject, GenProcID) select t.Object, t.SubObject, t.GenProcID from QBMDBQueuePond3 t where t.UID_Task = @UID_Task   and t.PondGroup = @PondGroup  group by t.Object, t.SubObject, t.GenProcID exec QBM_PDBQueueInsert_Int @UID_Task, @DBQueueElements4  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: return end 5