Back to OIM Explorer

dbo.ATT_P59CCD84DFA68B81E1B20B65_

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. References QBM_PJobCreate*

Source: sandbox-db sys.sql_modules

Source size: 756 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_HOTemplate source text reference
  • references source dbo.QBM_PJobCreate_HOTemplate_L source text reference

References

Referenced By

Complete Source

SQL31 lines
1CREATE PROCEDURE ATT_P59CCD84DFA68B81E1B20B65_(2  @Einzufuegen QBM_YParameterList READONLY,3  @HexPattern varchar(200),4  @GenProcID varchar(38)5)6AS7BEGIN8  DECLARE @Anzahl int9  DECLARE @DebugSwitch int = 010  DECLARE @XObjectKeys QBM_YParameterList11  INSERT INTO @XObjectKeys(Parameter1)12  SELECT e.Parameter313  FROM @Einzufuegen e14  WHERE15    e.Parameter1 LIKE @HexPattern16  SELECT @Anzahl = @@rowcount17  IF @DebugSwitch > 018  BEGIN19    print '  Jobs für ' + str(@Anzahl) + ' Sätze'20  END21  EXEC QBM_PJobCreate_HOTemplate_L 'HelperAttestationPolicy',22    @XObjectKeys,23    @Columns = 'DisplayName',24    @GenProcID = @GenProcID,25    @SingleTransaction = 0,26    @priority = 10,27    @isToFreezeOnError = 1,28    @Retries = 2,29    @CheckForExisting = 0,30    @AdditionalObjectKeysAffected = DEFAULT31END
Open raw exported source
SQL · Raw6 lines
1   create   procedure ATT_P59CCD84DFA68B81E1B20B65_ ( @Einzufuegen QBM_YParameterList readonly    , @HexPattern varchar(200) , @GenProcID varchar2(38) ) as begin declare @Anzahl int declare @DebugSwitch int = 0 declare @XObjectKeys QBM_YParameterList insert into @XObjectKeys (Parameter1) select e.Parameter33 from @Einzufuegen e where e.Parameter1 like @HexPattern  select @Anzahl = @@rowcount if @DebugSwitch > 0 begin print '  Jobs für ' + str(@Anzahl) + ' Sätze'4 end exec QBM_PJobCreate_HOTemplate_L 'HelperAttestationPolicy', @XObjectKeys, @Columns = 'DisplayName' , @GenProcID = @GenProcID , @SingleTransaction 5= 0 , @priority = 10 , @isToFreezeOnError = 1 , @Retries = 2 , @CheckForExisting = 0 , @AdditionalObjectKeysAffected = DEFAULT end 6