Back to OIM Explorer

dbo.QBM_ZIndexCreateGenerated

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 654 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_PIndexCreate source text reference
  • references source dbo.QBM_PIndexCreateGenerated source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.QBM_PTableLockEscalationSet source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL34 lines
1CREATE PROCEDURE QBM_ZIndexCreateGenerated(2  @SlotNumberDummy int,3  @TablePattern varchar(38),4  @dummy1 varchar(38) = '',5  @GenProcIDDummy varchar(38) = ''6)7AS8BEGIN9  DECLARE @ResetMessage nvarchar(4000)10  BEGIN TRY11    BEGIN TRY12      EXEC QBM_PTableLockEscalationSet @TablePattern13      EXEC QBM_PIndexCreateGenerated @TablePattern14    END TRY15    BEGIN CATCH16      EXEC QBM_PSessionErrorAdd DEFAULT17      SELECT @ResetMessage = ERROR_MESSAGE()18      IF @@TRANCOUNT > 019      BEGIN20        ROLLBACK21      END22      EXEC QBM_PDBQueueCurrentResetNGen @SlotNumberDummy,23        @ResetMessage,24        @@PROCID25    END CATCH26  END TRY27  BEGIN CATCH28    EXEC QBM_PSessionErrorAdd DEFAULT29    RAISERROR('',30    18,31    1)32      WITH NOWAIT33  END CATCH34END
Open raw exported source
SQL ยท Raw6 lines
1    create   procedure QBM_ZIndexCreateGenerated ( @SlotNumberDummy int , @TablePattern varchar(38), @dummy1 varchar(38) = '', @GenProcIDDummy varchar2(38) = '' ) as begin declare @ResetMessage nvarchar(4000) BEGIN TRY BEGIN TRY exec QBM_PTableLockEscalationSet @TablePattern exec QBM_PIndexCreateGenerated3 @TablePattern   END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default select @ResetMessage = ERROR_MESSAGE() if @@TRANCOUNT > 0 begin rollback end  exec4 QBM_PDBQueueCurrentResetNGen @SlotNumberDummy , @ResetMessage , @@PROCID END CATCH END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR (''5, 18, 1) WITH NOWAIT END CATCH end 6