Back to OIM Explorer

dbo.QBM_ZRITriggerCreateI

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 615 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_PDBQueueCurrentResetNGen source text reference
  • references source dbo.QBM_PRITriggerCreate source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.QBM_ZRITriggerCreate source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL37 lines
1CREATE PROCEDURE QBM_ZRITriggerCreateI(2  @SlotNumber int,3  @TableName varchar(38),4  @dummy varchar(38),5  @GenProcID varchar(38)6)7AS8BEGIN9  DECLARE @ResetMessage nvarchar(4000)10  DECLARE @DebugLevel char(1) = 'W'11  SET XACT_ABORT OFF12  BEGIN TRY13    BEGIN TRY14      EXEC QBM_PRITriggerCreate @TableName,15      'Insert'16    END TRY17    BEGIN CATCH18      SELECT @ResetMessage = ERROR_MESSAGE()19      IF @@TRANCOUNT > 020      BEGIN21        ROLLBACK22      END23      EXEC QBM_PDBQueueCurrentResetNGen @SlotNumber,24        @ResetMessage,25        @@PROCID26    END CATCH27  END TRY28  BEGIN CATCH29    EXEC QBM_PSessionErrorAdd DEFAULT30    RAISERROR('',31    18,32    1)33      WITH NOWAIT34  END CATCH35  endLabel:36  RETURN37END
Open raw exported source
SQL ยท Raw6 lines
1    create   procedure QBM_ZRITriggerCreateI (@SlotNumber int , @TableName varchar(38) , @dummy varchar(38)  , @GenProcID varchar(38) ) as begin2   declare @ResetMessage nvarchar(4000) declare @DebugLevel char(1) = 'W' SET XACT_ABORT OFF BEGIN TRY  BEGIN TRY exec QBM_PRITriggerCreate @TableName,3 'Insert' END TRY  BEGIN CATCH select @ResetMessage = ERROR_MESSAGE() if @@TRANCOUNT > 0 begin rollback end exec QBM_PDBQueueCurrentResetNGen @SlotNumber4 , @ResetMessage , @@PROCID END CATCH END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: return5 end 6