Back to OIM Explorer

dbo.QBM_PJobCreate_HOCallMethod_B

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. References QBM_PJobCreate*; References QBM_PJobCreate_HOCallMethod*

Source: sandbox-db sys.sql_modules

Source size: 3.156 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_FGISessionErrorRethrow source text reference
  • references source dbo.QBM_PJobCreate source text reference
  • references source dbo.QBM_PJobCreate_HOCallMethod source text reference
  • references source dbo.QBM_PJobCreate_HOCallMethod_L source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

Complete Source

SQL129 lines
1CREATE PROCEDURE QBM_PJobCreate_HOCallMethod_B(2  @objecttype nvarchar(255),3  @whereclause nvarchar(max),4  @save BIT,5  @MethodName nvarchar(256),6  @GenProcID varchar(38),7  @AdditionalObjectKeysAffected 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 @XObjectKeysToTransfer QBM_YParameterList35  DECLARE @SQLCmd nvarchar(max)36  SET XACT_ABORT OFF37  BEGIN TRY38    IF EXISTS(39      SELECT TOP 1 140      FROM DialogTable t41      WITH(readpast)42    JOIN DialogColumn c43      WITH(readpast)44      ON t.UID_DialogTable = c.UID_DialogTable45    WHERE46      t.TableName = @objecttype AND c.ColumnName = 'XObjectKey')47    BEGIN48      SELECT49        @SQLCmd = N '50	  select XObjectKey 51		from ' + @objecttype + N '52		where ( ' + @whereclause + N ' )53		order by 1 '54      INSERT INTO @XObjectKeysToTransfer(Parameter1)55      EXEC sp_executeSQL @SQLCmd56      EXEC QBM_PJobCreate_HOCallMethod_L @objecttype,57        @XObjectKeysToTransfer,58        @save,59        @MethodName,60        @GenProcID,61        @AdditionalObjectKeysAffected,62        @ConnectionVariables,63        @AuthenticationString,64        @SingleTransaction,65        @param1 = @param1,66        @param2 = @param2,67        @param3 = @param3,68        @param4 = @param4,69        @param5 = @param5,70        @param6 = @param6,71        @param7 = @param7,72        @param8 = @param8,73        @param9 = @param9,74        @param10 = @param10,75        @isToFreezeOnError = @isToFreezeOnError,76        @Retries = @Retries,77        @priority = @priority,78        @Jobchainname = @Jobchainname,79        @StartAt = @StartAt,80        @BasisObjectKey = @BasisObjectKey,81        @XUser = @XUser,82        @WhereClauseAdditional = @WhereClauseAdditional,83        @checkForExisting = @checkForExisting,84        @QueueName = @QueueName85    END86    ELSE87    BEGIN88      EXEC QBM_PJobCreate_HOCallMethod @objecttype,89        @whereclause,90        @save,91        @MethodName,92        @GenProcID,93        @AdditionalObjectKeysAffected,94        @ConnectionVariables,95        @AuthenticationString,96        @SingleTransaction,97        @param1 = @param1,98        @param2 = @param2,99        @param3 = @param3,100        @param4 = @param4,101        @param5 = @param5,102        @param6 = @param6,103        @param7 = @param7,104        @param8 = @param8,105        @param9 = @param9,106        @param10 = @param10,107        @isToFreezeOnError = @isToFreezeOnError,108        @Retries = @Retries,109        @priority = @priority,110        @Jobchainname = @Jobchainname,111        @StartAt = @StartAt,112        @BasisObjectKey = @BasisObjectKey,113        @XUser = @XUser,114        @WhereClauseAdditional = @WhereClauseAdditional,115        @checkForExisting = @checkForExisting,116        @QueueName = @QueueName117    END118  END TRY119  BEGIN CATCH120    EXEC QBM_PSessionErrorAdd DEFAULT121    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()122    RAISERROR(@Rethrow,123    18,124    1)125      WITH NOWAIT126  END CATCH127  ende:128  RETURN129END
Open raw exported source
SQL ยท Raw25 lines
1  create   procedure QBM_PJobCreate_HOCallMethod_B( @objecttype nvarchar(255),  @whereclause nvarchar(max)  , @save bit  , @MethodName nvarchar(2562)  , @GenProcID varchar(38) , @AdditionalObjectKeysAffected QBM_YParameterList readonly  , @ConnectionVariables nvarchar(max) = null , @AuthenticationString3 nvarchar(max) = null , @SingleTransaction bit = 1 , @param1 nvarchar(max) = null , @param2 nvarchar(max) = null , @param3 nvarchar(max) = null , @param44 nvarchar(max) = null , @param5 nvarchar(max) = null , @param6 nvarchar(max) = null , @param7 nvarchar(max) = null , @param8 nvarchar(max) = null , @param95 nvarchar(max) = null , @param10 nvarchar(max) = null , @isToFreezeOnError bit = 0 , @Retries int = 0 , @priority int = 5 , @Jobchainname nvarchar(256)6 = null , @StartAt datetime = null , @BasisObjectKey varchar(138) = '' , @XUser nvarchar(64) = null , @WhereClauseAdditional nvarchar(max) = '' , @checkForExisting7 bit = 0 , @QueueName nvarchar(256) = null ) as begin declare @XObjectKeysToTransfer QBM_YParameterList declare @SQLCmd nvarchar(max)  SET XACT_ABORT OFF8 BEGIN TRY if exists (select top 1 1 from DialogTable t with (readpast) join DialogColumn c with (readpast) on t.UID_DialogTable = c.UID_DialogTable where9 t.TableName = @objecttype and c.ColumnName = 'XObjectKey' ) begin select @SQLCmd = N'10	  select XObjectKey 11		from ' + @objecttype + N'12		where ( '13 + @whereclause + N' )14		order by 1 ' insert into @XObjectKeysToTransfer(Parameter1) exec sp_executeSQL @SQLCmd exec QBM_PJobCreate_HOCallMethod_L @objecttype15 , @XObjectKeysToTransfer , @save , @MethodName , @GenProcID , @AdditionalObjectKeysAffected , @ConnectionVariables , @AuthenticationString , @SingleTransaction16 , @param1 = @param1, @param2 = @param2, @param3 = @param3, @param4 = @param4, @param5 = @param5 , @param6 = @param6, @param7 = @param7, @param8 = @param817, @param9 = @param9, @param10 = @param10 , @isToFreezeOnError = @isToFreezeOnError , @Retries = @Retries , @priority = @priority , @Jobchainname = @Jobchainname18 , @StartAt = @StartAt , @BasisObjectKey = @BasisObjectKey , @XUser = @XUser , @WhereClauseAdditional = @WhereClauseAdditional , @checkForExisting = @checkForExisting19 , @QueueName = @QueueName end else begin exec QBM_PJobCreate_HOCallMethod @objecttype , @whereclause , @save , @MethodName , @GenProcID , @AdditionalObjectKeysAffected20 , @ConnectionVariables , @AuthenticationString , @SingleTransaction , @param1 = @param1, @param2 = @param2, @param3 = @param3, @param4 = @param4, @param521 = @param5 , @param6 = @param6, @param7 = @param7, @param8 = @param8, @param9 = @param9, @param10 = @param10 , @isToFreezeOnError = @isToFreezeOnError 22, @Retries = @Retries , @priority = @priority , @Jobchainname = @Jobchainname , @StartAt = @StartAt , @BasisObjectKey = @BasisObjectKey , @XUser = @XUser23 , @WhereClauseAdditional = @WhereClauseAdditional , @checkForExisting = @checkForExisting , @QueueName = @QueueName end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd24 default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH ende: return end 25