Back to OIM Explorer

dbo.QBM_ZColumnCheckBlobExternal

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. References QBM_PJobCreate*

Source: sandbox-db sys.sql_modules

Source size: 1.149 characters

Interpretation

  • Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.
  • Object-layer bridge detected through QBM_PJobCreate helper usage.

Relations

  • References QBM_PJobCreate*

Typed Edges

  • references source dbo.QBM_PColumnCheckBlobExternal source text reference
  • references source dbo.QBM_PJobCreate source text reference
  • references source dbo.QBM_PJobCreate_Mnt source text reference
  • references source dbo.QBM_PJournal source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL67 lines
1CREATE PROCEDURE QBM_ZColumnCheckBlobExternal(2  @SlotNumber int,3  @TableName varchar(38),4  @dummy1 varchar(38),5  @GenProcID varchar(38)6)7AS8BEGIN9  DECLARE @DebugSwitch int = 010  DECLARE @DebugMessage nvarchar(1000)11  DECLARE @DebugLevel char(1) = 'W'12  SET nocount13    ON14  SET XACT_ABORT OFF15  BEGIN TRY16    IF @GenProcID IS NULL OR ISNULL(@TableName,17    '') NOT IN(18    SELECT t.TableName19    FROM DialogTable t)20    BEGIN21      SELECT22        @DebugMessage = CONCAT(OBJECT_NAME(@@procid),23        ' empty values found ',24        ' GenProcID = ',25      CASE26        WHEN ISNULL(@GenProcID, '') = '' THEN27      ' <empty> '28      ELSE @GenProcID29      END,30      ' TableName = ',31      CASE32        WHEN ISNULL(@TableName, '') = '' THEN33      ' <empty> '34      ELSE @TableName35      END)36      EXEC QBM_PJournal @DebugMessage,37        @@procid,38      'D',39        @DebugLevel40      SELECT @GenProcID = NEWID()41    END42    IF 1=043    BEGIN44      EXEC QBM_PColumnCheckBlobExternal @TableName,45        @GenProcID46    END47    ELSE48    BEGIN49      DECLARE @SQL33734 nvarchar(max) = CONCAT('exec QBM_PColumnCheckBlobExternal ''',50      @TableName,51      ''', ''',52      @GenProcID,53      '''')54      EXEC QBM_PJobCreate_Mnt @SQL33734,55        @GenProcID56    END57  END TRY58  BEGIN CATCH59    EXEC QBM_PSessionErrorAdd DEFAULT60    RAISERROR('',61    18,62    1)63      WITH NOWAIT64  END CATCH65  ende:66  RETURN67END
Open raw exported source
SQL ยท Raw9 lines
1 create   procedure QBM_ZColumnCheckBlobExternal ( @SlotNumber int , @TableName varchar(38) , @dummy1 varchar(38) , @GenProcID varchar(38) ) as 2begin declare @DebugSwitch int = 0 declare @DebugMessage nvarchar (1000) declare @DebugLevel char(1) = 'W' set nocount on SET XACT_ABORT OFF BEGIN TRY 3if @GenProcID is null or ISNULL(@TableName, '') not in (select t.TableName from DialogTable t) begin select @DebugMessage = CONCAT( OBJECT_NAME(@@procid4) , ' empty values found ' , ' GenProcID = ' , case when ISNULL(@GenProcID, '') = '' then ' <empty> ' else @GenProcID end , ' TableName = ' , case when5 ISNULL(@TableName, '') = '' then ' <empty> ' else @TableName end ) exec QBM_PJournal @DebugMessage, @@procid, 'D', @DebugLevel select @GenProcID = NEWID6() end if 1=0 begin exec QBM_PColumnCheckBlobExternal @TableName, @GenProcID end else begin declare @SQL33734 nvarchar(max) = concat('exec QBM_PColumnCheckBlobExternal '''7, @TableName, ''', ''', @GenProcID , '''' ) exec QBM_PJobCreate_Mnt @SQL33734, @GenProcID end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR8 ('', 18, 1) WITH NOWAIT END CATCH  ende:  return end 9