Back to OIM Explorer

dbo.QER_ZITShopHelperFill

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 625 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_PSessionErrorAdd source text reference
  • references source dbo.QBM_PWaitForSeconds source text reference
  • references source dbo.QER_PITShopHelperFill source text reference
  • references source dbo.QER_PITShopHelperFill_bulk source text reference

References

Referenced By

Complete Source

SQL41 lines
1CREATE PROCEDURE QER_ZITShopHelperFill(2  @SlotNumber int3)4AS5BEGIN6  DECLARE @PWOsToFill QBM_YParameterlist7  DECLARE @DebugSwitch int = 08  BEGIN TRY9    IF @DebugSwitch > 010    BEGIN11      EXEC QBM_PWaitForSeconds 0.512    END13    INSERT INTO @PWOsToFill(Parameter1,14    Parameter2,15    Parameter3,16    HasContentFull)17    SELECT18      uid_parameter,19      GenprocID,20      '0',21      022    FROM QBMDBQueueCurrent cu23      WITH(readpast)24    WHERE25      cu.SlotNumber = @SlotNumber26    IF @@rowcount = 027    BEGIN28      GOTO EndLabel29    END30    EXEC QER_PITShopHelperFill_bulk @PWOsToFill31  END TRY32  BEGIN CATCH33    EXEC QBM_PSessionErrorAdd DEFAULT34    RAISERROR('',35    18,36    1)37      WITH NOWAIT38  END CATCH39  endLabel:40  RETURN41END
Open raw exported source
SQL ยท Raw6 lines
1     create   procedure QER_ZITShopHelperFill (@SlotNumber int) as begin  declare @PWOsToFill QBM_YParameterlist      declare @DebugSwitch int =2 0 BEGIN TRY if @DebugSwitch > 0 begin exec QBM_PWaitForSeconds 0.5 end insert into @PWOsToFill(Parameter1, Parameter2, Parameter3, HasContentFull) select3 uid_parameter, GenprocID, '0', 0 from QBMDBQueueCurrent cu with (readpast) where cu.SlotNumber = @SlotNumber if @@rowcount = 0 begin goto EndLabel end4  exec QER_PITShopHelperFill_bulk @PWOsToFill  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel:5 return end 6