Back to OIM Explorer

dbo.QBM_PJobCreate_HOCallMethod

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. References QBM_PJobCreate*; References QBM_PJobCreate_HOCallMethod*

Source: sandbox-db sys.sql_modules

Source size: 2.828 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*
  • References QBM_PJobCreate_HOCallMethod*

Typed Edges

  • references source dbo.QBM_FGIJobCreateName source text reference
  • references source dbo.QBM_FGISessionErrorRethrow source text reference
  • references source dbo.QBM_PJobCreate source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

Complete Source

SQL118 lines
1CREATE PROCEDURE QBM_PJobCreate_HOCallMethod(2  @objecttype nvarchar(255),3  @whereclause nvarchar(max),4  @save BIT,5  @MethodName nvarchar(256),6  @GenProcID varchar(38),7  @ObjectKeysAffected QBM_YParameterList READONLY,8  @ConnectionVariables nvarchar(max) = NULL,9  @AuthenticationString nvarchar(max) = NULL,10  @SingleTransaction BIT = 1,11  @param1 nvarchar(max) = NULL,12  @param2 nvarchar(max) = NULL,13  @param3 nvarchar(max) = NULL,14  @param4 nvarchar(max) = NULL,15  @param5 nvarchar(max) = NULL,16  @param6 nvarchar(max) = NULL,17  @param7 nvarchar(max) = NULL,18  @param8 nvarchar(max) = NULL,19  @param9 nvarchar(max) = NULL,20  @param10 nvarchar(max) = NULL,21  @isToFreezeOnError BIT = 0,22  @Retries int = 0,23  @priority int = 5,24  @Jobchainname nvarchar(256) = NULL,25  @StartAt datetime = NULL,26  @BasisObjectKey varchar(138) = '',27  @XUser nvarchar(64) = NULL,28  @WhereClauseAdditional nvarchar(max) = '',29  @checkForExisting BIT = 0,30  @QueueName nvarchar(256) = NULL31)32AS33BEGIN34  DECLARE @Parameters QBM_YParameterList35  DECLARE @JobChainNameAddOn nvarchar(256)36  SET XACT_ABORT OFF37  BEGIN TRY38    IF @Jobchainname IS NULL39    BEGIN40      SELECT41        @JobChainNameAddOn = ' call method ' + @MethodName + ' for object type ' + @objecttype42      SELECT @Jobchainname =dbo.QBM_FGIJobCreateName(@JobChainNameAddOn)43    END44    INSERT INTO @Parameters(Parameter1,45    ContentFull)46    SELECT47      x.Parameter1,48      x.ContentFull49    FROM(50    VALUES('objecttype', @objecttype),51    ('WhereClause', @whereclause),52    ('WhereClauseAdditional', @WhereClauseAdditional),53    ('Save', CASE @save54    WHEN 1 THEN55    'True'56    ELSE 'False'57    END),58    ('MethodName', @MethodName),59    ('param1', @param1),60    ('param2', @param2),61    ('param3', @param3),62    ('param4', @param4),63    ('param5', @param5),64    ('param6', @param6),65    ('param7', @param7),66    ('param8', @param8),67    ('param9', @param9),68    ('param10', @param10)) AS x(Parameter1,69    ContentFull)70    WHERE71      NOT(Parameter1 LIKE 'param%' AND ContentFull IS NULL)72    IF @ConnectionVariables > ' '73    BEGIN74      INSERT INTO @Parameters(Parameter1,75      ContentFull)76      VALUES('ConnectionVariables',77      @ConnectionVariables)78    END79    IF @AuthenticationString > ' '80    BEGIN81      INSERT INTO @Parameters(Parameter1,82      ContentFull)83      VALUES('AuthenticationString',84      @AuthenticationString)85    END86    IF @SingleTransaction = 087    BEGIN88      INSERT INTO @Parameters(Parameter1,89      ContentFull)90      VALUES('SingleTransaction',91      'FALSE')92    END93    EXEC QBM_PJobCreate 'VI.JobService.JobComponents.HandleObjectComponent',94    'CallMethod',95      @Parameters,96      @GenProcID,97      @ObjectKeysAffected,98      @isToFreezeOnError,99      @Retries,100      @priority,101      @Jobchainname,102      @StartAt,103      @BasisObjectKey,104      @XUser,105      @QueueName,106      @checkForExisting107  END TRY108  BEGIN CATCH109    EXEC QBM_PSessionErrorAdd DEFAULT110    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()111    RAISERROR(@Rethrow,112    18,113    1)114      WITH NOWAIT115  END CATCH116  ende:117  RETURN118END
Open raw exported source
SQL ยท Raw20 lines
1 create   procedure QBM_PJobCreate_HOCallMethod( @objecttype nvarchar(255),  @whereclause nvarchar(max)  , @save bit  , @MethodName nvarchar(2562)  , @GenProcID varchar(38) , @ObjectKeysAffected QBM_YParameterList readOnly  , @ConnectionVariables nvarchar(max) = null , @AuthenticationString nvarchar3(max) = null , @SingleTransaction bit = 1 , @param1 nvarchar(max) = null , @param2 nvarchar(max) = null , @param3 nvarchar(max) = null , @param4 nvarchar4(max) = null , @param5 nvarchar(max) = null , @param6 nvarchar(max) = null , @param7 nvarchar(max) = null , @param8 nvarchar(max) = null , @param9 nvarchar5(max) = null , @param10 nvarchar(max) = null , @isToFreezeOnError bit = 0 , @Retries int = 0 , @priority int = 5 , @Jobchainname nvarchar(256) = null ,6 @StartAt datetime = null , @BasisObjectKey varchar(138) = '' , @XUser nvarchar(64) = null , @WhereClauseAdditional nvarchar(max) = '' , @checkForExisting7 bit = 0 , @QueueName nvarchar(256) = null ) as begin declare @Parameters QBM_YParameterList declare @JobChainNameAddOn nvarchar(256) SET XACT_ABORT OFF8 BEGIN TRY if @Jobchainname is null begin select @JobChainNameAddOn = ' call method ' + @MethodName + ' for object type ' + @objecttype select @Jobchainname9 =dbo.QBM_FGIJobCreateName ( @JobChainNameAddOn) end insert into @Parameters (Parameter1, ContentFull) select x.Parameter1, x.ContentFull from ( values10 ('objecttype', @objecttype) , ('WhereClause', @whereclause) , ('WhereClauseAdditional', @WhereClauseAdditional)  , ( 'Save' , case @save when 1 then 'True'11 else 'False' end ) , ('MethodName', @MethodName) , ( 'param1' , @param1 ) , ( 'param2' , @param2 ) , ( 'param3' , @param3 ) , ( 'param4' , @param4 ) ,12 ( 'param5' , @param5 ) , ( 'param6' , @param6 ) , ( 'param7' , @param7 ) , ( 'param8' , @param8 ) , ( 'param9' , @param9 ) , ( 'param10' , @param10 ) 13) as x (Parameter1, ContentFull)  where not ( Parameter1 like 'param%' and ContentFull is null ) if @ConnectionVariables > ' ' begin insert into @Parameters14(Parameter1, ContentFull) values ('ConnectionVariables', @ConnectionVariables) end if @AuthenticationString > ' ' begin insert into @Parameters(Parameter115, ContentFull) values ('AuthenticationString', @AuthenticationString) end if @SingleTransaction = 0 begin insert into @Parameters(Parameter1, ContentFull16) values ('SingleTransaction', 'FALSE') end exec QBM_PJobCreate 'VI.JobService.JobComponents.HandleObjectComponent' , 'CallMethod' , @Parameters , @GenProcID17 , @ObjectKeysAffected , @isToFreezeOnError , @Retries , @priority , @Jobchainname , @StartAt , @BasisObjectKey , @XUser , @QueueName , @checkForExisting18 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH19 NOWAIT END CATCH ende: return end 20