Back to OIM Explorer

dbo.QER_PDynamicGroupMakeProc_Drop

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 661 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.QER_FCVDynGuidToProcName source text reference
  • references source dbo.QBM_PProcedureDrop source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

Complete Source

SQL27 lines
1CREATE PROCEDURE QER_PDynamicGroupMakeProc_Drop(2  @UID_DynamicGroup varchar(38)3)4AS5BEGIN6  DECLARE @ProcNameRechneAlle nvarchar(64)7  DECLARE @ProcNameRechneDetail nvarchar(64)8  SET XACT_ABORT OFF9  BEGIN TRY10    SELECT11      @ProcNameRechneAlle = dbo.QER_FCVDynGuidToProcName(@UID_DynamicGroup,12      'All')13    EXEC QBM_PProcedureDrop @ProcNameRechneAlle14    SELECT15      @ProcNameRechneDetail = dbo.QER_FCVDynGuidToProcName(@UID_DynamicGroup,16      'Detail')17    EXEC QBM_PProcedureDrop @ProcNameRechneDetail18  END TRY19  BEGIN CATCH20    EXEC QBM_PSessionErrorAdd DEFAULT21    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()22    RAISERROR(@Rethrow,23    18,24    1)25      WITH NOWAIT26  END CATCH27END
Open raw exported source
SQL ยท Raw6 lines
1          create   procedure QER_PDynamicGroupMakeProc_Drop (@UID_DynamicGroup varchar(38)) as begin declare @ProcNameRechneAlle nvarchar(64) declare2 @ProcNameRechneDetail nvarchar(64) SET XACT_ABORT OFF BEGIN TRY select @ProcNameRechneAlle = dbo.QER_FCVDynGuidToProcName(@UID_DynamicGroup, 'All') exec3 QBM_PProcedureDrop @ProcNameRechneAlle select @ProcNameRechneDetail = dbo.QER_FCVDynGuidToProcName(@UID_DynamicGroup, 'Detail') exec QBM_PProcedureDrop4 @ProcNameRechneDetail END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR5 (@Rethrow, 18, 1) WITH NOWAIT END CATCH end 6