Back to OIM Explorer

dbo.QBM_PFESimulationEnd

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

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

SQL27 lines
1CREATE PROCEDURE QBM_PFESimulationEnd(2  @UID_Database varchar(38),3  @XUserUpdated nvarchar(64),4  @XDateUpdated datetime5)6AS7BEGIN8  SET XACT_ABORT OFF9  BEGIN TRY10    UPDATE Dialogdatabase11    SET FESimulationStarted = NULL,12    XUserUpdated = @XUserUpdated,13    XDateUpdated = @XDateUpdated14    WHERE15      UID_Database = @UID_Database16  END TRY17  BEGIN CATCH18    EXEC QBM_PSessionErrorAdd DEFAULT19    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()20    RAISERROR(@Rethrow,21    18,22    1)23      WITH NOWAIT24  END CATCH25  endLabel:26  RETURN27END
Open raw exported source
SQL ยท Raw5 lines
1 create   procedure QBM_PFESimulationEnd (@UID_Database varchar(38) , @XUserUpdated nvarchar(64) , @XDateUpdated datetime ) as begin SET XACT_ABORT2 OFF BEGIN TRY update Dialogdatabase set FESimulationStarted = null , XUserUpdated = @XUserUpdated , XDateUpdated = @XDateUpdated where UID_Database = 3@UID_Database END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow4, 18, 1) WITH NOWAIT END CATCH endLabel: return end 5