Back to OIM Explorer

dbo.QBM_PProcessCreate

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

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

References

Referenced By

Complete Source

SQL51 lines
1CREATE PROCEDURE QBM_PProcessCreate(2  @GenProcID varchar(38),3  @Xuser nvarchar(64),4  @BasisObjectType nvarchar(255) = N '',5  @ObjectKey varchar(138) = NULL,6  @DisplayName nvarchar(255) = N ''7)8AS9BEGIN10  SET XACT_ABORT OFF11  BEGIN TRY12    INSERT INTO DialogProcess(GenProcID,13    BasisObjectType,14    ObjectKey,15    ProcessState,16    XDateInserted,17    XDateUpdated,18    XUserInserted,19    XUserUpdated,20    CustomComment,21    XTouched,22    DisplayName)23    SELECT24      @GenProcID,25      @BasisObjectType,26      @ObjectKey,27      'E',28      GetUTCDate(),29      GetUTCDate(),30      @XUser,31      @XUser,32      N '',33      N '',34      @DisplayName35    WHERE36      NOT EXISTS(37    SELECT TOP 1 138    FROM DialogProcess p39      WITH(nolock)40    WHERE41      p.GenProcID = @GenProcID)42  END TRY43  BEGIN CATCH44    EXEC QBM_PSessionErrorAdd DEFAULT45    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()46    RAISERROR(@Rethrow,47    18,48    1)49      WITH NOWAIT50  END CATCH51END
Open raw exported source
SQL ยท Raw7 lines
1    create   procedure QBM_PProcessCreate (@GenProcID varchar(38), @Xuser nvarchar(64), @BasisObjectType nvarchar(255) = N'', @ObjectKey varchar2(138) = null, @DisplayName nvarchar(255) = N'' ) as begin SET XACT_ABORT OFF BEGIN TRY insert into DialogProcess (GenProcID , BasisObjectType , ObjectKey3 , ProcessState, XDateInserted , XDateUpdated , XUserInserted , XUserUpdated , CustomComment, XTouched, DisplayName ) select @GenProcID, @BasisObjectType4, @ObjectKey, 'E', GetUTCDate(), GetUTCDate() , @XUser , @XUser , N'' , N'', @DisplayName where Not exists (select top 1 1 from DialogProcess p with(nolock5) where p.GenProcID = @GenProcID ) END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow6() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH end 7