Back to OIM Explorer

dbo.QBM_P4B5EF97051B7F5A66DC5668_

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. HOCallMethod -> .@save at line 13; References QBM_PJobCreate*; References QBM_PJobCreate_HOCallMethod*

Source: sandbox-db sys.sql_modules

Source size: 2.500 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

  • HOCallMethod -> .@save at line 13
  • References QBM_PJobCreate*
  • References QBM_PJobCreate_HOCallMethod*

Typed Edges

  • references source dbo.QBM_FCVParameter1AsOneInClause source text reference
  • references source dbo.QBM_PJobCreate source text reference
  • references source dbo.QBM_PJobCreate_HOCallMethod source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

Complete Source

SQL115 lines
1CREATE PROCEDURE QBM_P4B5EF97051B7F5A66DC5668_(2  @Portion int,3  @AllObjectKeysIn QBM_YObjectKeyAndPortion READONLY,4  @objecttype nvarchar(255),5  @save BIT,6  @MethodName nvarchar(256),7  @GenProcID varchar(38),8  @AdditionalObjectKeysAffected QBM_YParameterList READONLY,9  @ConnectionVariables nvarchar(max) = NULL,10  @AuthenticationString nvarchar(max) = NULL,11  @SingleTransaction BIT = 1,12  @param1 nvarchar(max) = NULL,13  @param2 nvarchar(max) = NULL,14  @param3 nvarchar(max) = NULL,15  @param4 nvarchar(max) = NULL,16  @param5 nvarchar(max) = NULL,17  @param6 nvarchar(max) = NULL,18  @param7 nvarchar(max) = NULL,19  @param8 nvarchar(max) = NULL,20  @param9 nvarchar(max) = NULL,21  @param10 nvarchar(max) = NULL,22  @isToFreezeOnError BIT = 0,23  @Retries int = 0,24  @priority int = 5,25  @Jobchainname nvarchar(256) = NULL,26  @StartAt datetime = NULL,27  @BasisObjectKey varchar(138) = '',28  @XUser nvarchar(64) = NULL,29  @WhereClauseAdditional nvarchar(max) = '',30  @checkForExisting BIT = 0,31  @QueueName nvarchar(256) = NULL32)33AS34BEGIN35  DECLARE @ObjectKeys_Part QBM_YParameterList36  DECLARE @Sammler nvarchar(max)37  DECLARE @ObjectKeysAffected QBM_YParameterList38  SET XACT_ABORT OFF39  BEGIN TRY40    INSERT INTO @ObjectKeys_Part(Parameter1)41    SELECT i.Objectkey42    FROM @AllObjectKeysIn i43    WHERE44      i.Portion = @Portion45    IF @@ROWCOUNT = 046    BEGIN47      GOTO endLabel48    END49    SELECT50      @sammler = CONCAT('XObjectKey in ',51      dbo.QBM_FCVParameter1AsOneInClause(@ObjectKeys_Part))52    IF NOT EXISTS(53      SELECT TOP 1 154      FROM @AdditionalObjectKeysAffected55      WHERE56        Parameter1 > ' ' AND Parameter2 IS NULL)57    BEGIN58      INSERT INTO @ObjectKeysAffected(Parameter1)59      SELECT a.Parameter160      FROM @AdditionalObjectKeysAffected a61      JOIN @ObjectKeys_Part s62        ON a.Parameter2 = s.Parameter163      UNION64      SELECT Parameter165      FROM @ObjectKeys_Part66    END67    ELSE68    BEGIN69      INSERT INTO @ObjectKeysAffected(Parameter1)70      SELECT a.Parameter171      FROM @AdditionalObjectKeysAffected a72      UNION73      SELECT Parameter174      FROM @ObjectKeys_Part75    END76    EXEC QBM_PJobCreate_HOCallMethod @objecttype,77      @Sammler,78      @save,79      @MethodName,80      @GenProcID,81      @ObjectKeysAffected,82      @ConnectionVariables,83      @AuthenticationString,84      @SingleTransaction,85      @param1,86      @param2,87      @param3,88      @param4,89      @param5,90      @param6,91      @param7,92      @param8,93      @param9,94      @param10,95      @isToFreezeOnError,96      @Retries,97      @priority,98      @Jobchainname,99      @StartAt,100      @BasisObjectKey,101      @XUser,102      @WhereClauseAdditional,103      @checkForExisting,104      @QueueName105  END TRY106  BEGIN CATCH107    EXEC QBM_PSessionErrorAdd DEFAULT108    RAISERROR('',109    18,110    1)111      WITH NOWAIT112  END CATCH113  endLabel:114  RETURN115END
Open raw exported source
SQL ยท Raw17 lines
1create   procedure QBM_P4B5EF97051B7F5A66DC5668_ ( @Portion int , @AllObjectKeysIn QBM_YObjectKeyAndPortion readonly  , @objecttype nvarchar(2552)      , @save bit  , @MethodName nvarchar(256)  , @GenProcID varchar(38) , @AdditionalObjectKeysAffected QBM_YParameterList readonly    , @ConnectionVariables3 nvarchar(max) = null , @AuthenticationString nvarchar(max) = null , @SingleTransaction bit = 1 , @param1 nvarchar(max) = null , @param2 nvarchar(max) 4= null , @param3 nvarchar(max) = null , @param4 nvarchar(max) = null , @param5 nvarchar(max) = null , @param6 nvarchar(max) = null , @param7 nvarchar(max5) = null , @param8 nvarchar(max) = null , @param9 nvarchar(max) = null , @param10 nvarchar(max) = null , @isToFreezeOnError bit = 0 , @Retries int = 0 6, @priority int = 5 , @Jobchainname nvarchar(256) = null , @StartAt datetime = null , @BasisObjectKey varchar(138) = '' , @XUser nvarchar(64) = null , 7@WhereClauseAdditional nvarchar(max) = '' , @checkForExisting bit = 0 , @QueueName nvarchar(256) = null ) as begin declare @ObjectKeys_Part QBM_YParameterList8 declare @Sammler nvarchar(max) declare @ObjectKeysAffected QBM_YParameterList SET XACT_ABORT OFF BEGIN TRY insert into @ObjectKeys_Part(Parameter1) select9 i.Objectkey from @AllObjectKeysIn i where i.Portion = @Portion if @@ROWCOUNT = 0 begin goto endLabel end select @sammler = concat('XObjectKey in ' , dbo.QBM_FCVParameter1AsOneInClause10(@ObjectKeys_Part) )  if not exists (select top 1 1 from @AdditionalObjectKeysAffected where Parameter1 > ' ' and Parameter2 is null ) begin insert into11 @ObjectKeysAffected(Parameter1) select a.Parameter1 from @AdditionalObjectKeysAffected a join @ObjectKeys_Part s on a.Parameter2 = s.Parameter1 union 12select Parameter1 from @ObjectKeys_Part end else begin  insert into @ObjectKeysAffected(Parameter1) select a.Parameter1 from @AdditionalObjectKeysAffected13 a union select Parameter1 from @ObjectKeys_Part end exec QBM_PJobCreate_HOCallMethod @objecttype , @Sammler , @save , @MethodName , @GenProcID , @ObjectKeysAffected14 , @ConnectionVariables , @AuthenticationString , @SingleTransaction , @param1 , @param2 , @param3 , @param4, @param5 , @param6, @param7, @param8, @param915, @param10 , @isToFreezeOnError , @Retries , @priority , @Jobchainname , @StartAt , @BasisObjectKey , @XUser , @WhereClauseAdditional , @checkForExisting16 , @QueueName END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: return end 17