Back to OIM Explorer

dbo.QBM_PBufferT_FillOneObject

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 796 characters

Interpretation

  • Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.

Relations

  • No extracted relations.

Typed Edges

  • references source dbo.QBM_FCVObjectkeyToElement source text reference
  • references source dbo.QBM_FGIDBOwner source text reference
  • references source dbo.QBM_FGISessionErrorRethrow source text reference
  • references source dbo.QBM_PBufferT_FillTable source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL35 lines
1CREATE PROCEDURE QBM_PBufferT_FillOneObject(2  @TempTableName nvarchar(64),3  @XObjectKey varchar(138),4  @TargetModule varchar(3) = '#'5)6AS7BEGIN8  DECLARE @TableName varchar(30)9  DECLARE @ModuleName varchar(3)10  DECLARE @Rowcondition nvarchar(max)11  SET XACT_ABORT OFF12  BEGIN TRY13    SELECT @ModuleName = dbo.QBM_FGIDBOwner()14    IF @TargetModule = '#'15    BEGIN16      SELECT @TargetModule = @ModuleName17    END18    SELECT19      @TableName = dbo.QBM_FCVObjectkeyToElement('TableName',20      @XObjectKey)21    SELECT @Rowcondition = ' ( XObjectKey = ''' + @XObjectKey + ''' )'22    EXEC QBM_PBufferT_FillTable @TempTableName,23      @TargetModule,24      @TableName,25    '1=1'26  END TRY27  BEGIN CATCH28    EXEC QBM_PSessionErrorAdd DEFAULT29    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()30    RAISERROR(@Rethrow,31    18,32    1)33      WITH NOWAIT34  END CATCH35END
Open raw exported source
SQL ยท Raw7 lines
1  create   procedure QBM_PBufferT_FillOneObject ( @TempTableName nvarchar(64) , @XObjectKey varchar(138) , @TargetModule varchar(3) = '#' ) as begin2 declare @TableName varchar(30)  declare @ModuleName varchar(3) declare @Rowcondition nvarchar(max) SET XACT_ABORT OFF BEGIN TRY select @ModuleName = dbo.QBM_FGIDBOwner3() if @TargetModule = '#' begin select @TargetModule = @ModuleName end select @TableName = dbo.QBM_FCVObjectkeyToElement('TableName', @XObjectKey) select4 @Rowcondition = ' ( XObjectKey = ''' + @XObjectKey + ''' )' exec QBM_PBufferT_FillTable @TempTableName , @TargetModule , @TableName , '1=1' END TRY BEGIN5 CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END 6CATCH end 7