Back to OIM Explorer

dbo.QBM_PFESimulationStart

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

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

  • No direct source references extracted.

Complete Source

SQL28 lines
1CREATE PROCEDURE QBM_PFESimulationStart(2  @UID_Database varchar(38),3  @SimulationStart datetime,4  @XUserUpdated nvarchar(64),5  @XDateUpdated datetime6)7AS8BEGIN9  SET XACT_ABORT OFF10  BEGIN TRY11    UPDATE Dialogdatabase12    SET FESimulationStarted = @SimulationStart,13    XUserUpdated = @XUserUpdated,14    XDateUpdated = @XDateUpdated15    WHERE16      UID_Database = @UID_Database17  END TRY18  BEGIN CATCH19    EXEC QBM_PSessionErrorAdd DEFAULT20    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()21    RAISERROR(@Rethrow,22    18,23    1)24      WITH NOWAIT25  END CATCH26  endLabel:27  RETURN28END
Open raw exported source
SQL ยท Raw5 lines
1 create   procedure QBM_PFESimulationStart (@UID_Database varchar(38) , @SimulationStart datetime , @XUserUpdated nvarchar(64) , @XDateUpdated datetime2 ) as begin SET XACT_ABORT OFF BEGIN TRY update Dialogdatabase set FESimulationStarted = @SimulationStart , XUserUpdated = @XUserUpdated , XDateUpdated3 = @XDateUpdated where UID_Database = @UID_Database END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow4() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH endLabel: return end 5