Back to OIM Explorer

dbo.QBM_PProcedureNestLevelCheck

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 700 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_PSessionErrorAdd source text reference

References

Referenced By

Complete Source

SQL36 lines
1CREATE PROCEDURE QBM_PProcedureNestLevelCheck(2  @ProcID int3)4AS5BEGIN6  DECLARE @errmsg nvarchar(255)7  DECLARE @ProcName nvarchar(255)8  SET XACT_ABORT OFF9  BEGIN TRY10    SELECT11      @ProcName = isnull(OBJECT_NAME(@ProcID),12      '<no procedure>')13    SELECT14      @errmsg = nchar(9) + N 'NL ' + convert(nvarchar(16),15      @@nestlevel) + nchar(9) + @procname16    IF @@nestlevel < 3017    BEGIN18      RETURN19    END20    SELECT21      @errmsg = N 'Nestlevel ' + convert(nvarchar(16),22      @@nestlevel) + N ' detected in procedure ' + @Procname23    RAISERROR(@errmsg,24    18,25    1)26      WITH nowait27  END TRY28  BEGIN CATCH29    EXEC QBM_PSessionErrorAdd DEFAULT30    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()31    RAISERROR(@Rethrow,32    18,33    1)34      WITH NOWAIT35  END CATCH36END
Open raw exported source
SQL ยท Raw6 lines
1    create   procedure QBM_PProcedureNestLevelCheck (@ProcID int) as begin declare @errmsg nvarchar(255) declare @ProcName nvarchar(255)  SET XACT_ABORT2 OFF BEGIN TRY select @ProcName = isnull(OBJECT_NAME(@ProcID ), '<no procedure>') select @errmsg = nchar(9) + N'NL ' + convert(nvarchar(16), @@nestlevel3) + nchar(9) + @procname  if @@nestlevel < 30 begin return end select @errmsg = N'Nestlevel ' + convert(nvarchar(16), @@nestlevel) + N' detected in procedure '4 + @Procname raiserror (@errmsg, 18, 1 ) with nowait END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow5() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH end 6