Back to OIM Explorer

dbo.QBM_PDeleteDeep

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 558 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_PDeleteDeep_L source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.QBM_PTriggerEnable source text reference

References

Referenced By

Complete Source

SQL29 lines
1CREATE PROCEDURE QBM_PDeleteDeep(2  @ObjectKeyStart varchar(138),3  @SingleElementProcess BIT = 0,4  @TestOnly BIT = 05)6AS7BEGIN8  DECLARE @ObjectKeys QBM_YParameterList9  SET XACT_ABORT OFF10  BEGIN TRY11    INSERT INTO @ObjectKeys(Parameter1)12    SELECT @ObjectKeyStart13    EXEC QBM_PDeleteDeep_L @ObjectKeys,14      @SingleElementProcess,15      @TestOnly16  END TRY17  BEGIN CATCH18    EXEC QBM_PSessionErrorAdd DEFAULT19    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()20    RAISERROR(@Rethrow,21    18,22    1)23      WITH NOWAIT24  END CATCH25  ende:26  EXEC QBM_PTriggerEnable '%',27  '%'28  RETURN29END
Open raw exported source
SQL ยท Raw5 lines
1  create   procedure QBM_PDeleteDeep (@ObjectKeyStart varchar(138) , @SingleElementProcess bit = 0   , @TestOnly bit = 0  ) as begin declare @ObjectKeys2 QBM_YParameterList SET XACT_ABORT OFF BEGIN TRY insert into @ObjectKeys(Parameter1) select @ObjectKeyStart exec QBM_PDeleteDeep_L @ObjectKeys, @SingleElementProcess3, @TestOnly END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow4, 18, 1) WITH NOWAIT END CATCH ende: exec QBM_PTriggerEnable '%', '%'  return end 5