Back to OIM Explorer

dbo.QER_PQERBufferRecalcDMDel

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 512 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 source dbo.QER_P98F5E10C6A9349A1EBFB2C2_ source text reference

References

Referenced By

Complete Source

SQL26 lines
1CREATE PROCEDURE QER_PQERBufferRecalcDMDel(2  @UsageArea varchar(1)3)4AS5BEGIN6  DECLARE @Lauf int = 17  SET XACT_ABORT OFF8  BEGIN TRY9    SET deadlock_priority -1010    SET lock_timeout 5011    WHILE @Lauf > 012    BEGIN13      EXEC @Lauf = QER_P98F5E10C6A9349A1EBFB2C2_ @UsageArea14    END15  END TRY16  BEGIN CATCH17    EXEC QBM_PSessionErrorAdd DEFAULT18    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()19    RAISERROR(@Rethrow,20    18,21    1)22      WITH NOWAIT23  END CATCH24  SET lock_timeout -1 endLabel:25  RETURN26END
Open raw exported source
SQL ยท Raw5 lines
1create   procedure QER_PQERBufferRecalcDMDel (@UsageArea varchar(1) ) as begin declare @Lauf int = 1 SET XACT_ABORT OFF BEGIN TRY set deadlock_priority2 -10  set lock_timeout 50              while @Lauf > 0 begin exec @Lauf = QER_P98F5E10C6A9349A1EBFB2C2_ @UsageArea                       end END TRY BEGIN3 CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END 4CATCH set lock_timeout -1 endLabel:  return end 5