Back to OIM Explorer

dbo.QBM_ZTableRevisionFill

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. References QBM_PJobCreate*

Source: sandbox-db sys.sql_modules

Source size: 551 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_PJobCreate source text reference
  • references source dbo.QBM_PJobCreate_Mnt source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.QBM_PTableRevisionFill source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL33 lines
1CREATE PROCEDURE QBM_ZTableRevisionFill(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  BEGIN TRY13    IF 1=014    BEGIN15      EXEC QBM_PTableRevisionFill16    END17    ELSE18    BEGIN19      DECLARE @SQL33734 nvarchar(max) = 'exec QBM_PTableRevisionFill '20      EXEC QBM_PJobCreate_Mnt @SQL33734,21        @GenProcID22    END23  END TRY24  BEGIN CATCH25    EXEC QBM_PSessionErrorAdd DEFAULT26    RAISERROR('',27    18,28    1)29      WITH NOWAIT30  END CATCH31  ende:32  RETURN33END
Open raw exported source
SQL ยท Raw5 lines
1   create   procedure QBM_ZTableRevisionFill ( @Slotnumber int , @TableName varchar(38) , @dummy1 varchar(38) , @GenProcID varchar(38) ) as begin2 declare @DebugSwitch int = 0 declare @DebugMessage nvarchar (1000) declare @DebugLevel char(1) = 'W' BEGIN TRY if 1=0 begin exec QBM_PTableRevisionFill3 end else begin declare @SQL33734 nvarchar(max) = 'exec QBM_PTableRevisionFill ' exec QBM_PJobCreate_Mnt @SQL33734, @GenProcID end END TRY BEGIN CATCH 4exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 5