Back to OIM Explorer

dbo.QER_ZITShopPersonHasObjectFill

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 569 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.QER_PITShopPersonHasObjFill_b source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL31 lines
1CREATE PROCEDURE QER_ZITShopPersonHasObjectFill(2  @SlotNumber int3)4AS5BEGIN6  DECLARE @PWOsToFill QBM_YParameterlist7  BEGIN TRY8    DELETE @PWOsToFill9    INSERT INTO @PWOsToFill(Parameter1,10    Parameter2)11    SELECT12      p.uid_parameter,13      p.GenprocID14    FROM QBMDBQueueCurrent p15      WITH(readpast)16    JOIN personwantsorg pwo17      ON p.uid_parameter = pwo.uid_personwantsorg18    WHERE19      p.SlotNumber = @SlotNumber20    EXEC QER_PITShopPersonHasObjFill_b @PWOsToFill21  END TRY22  BEGIN CATCH23    EXEC QBM_PSessionErrorAdd DEFAULT24    RAISERROR('',25    18,26    1)27      WITH NOWAIT28  END CATCH29  ende:30  RETURN31END
Open raw exported source
SQL ยท Raw5 lines
1    create   procedure QER_ZITShopPersonHasObjectFill (@SlotNumber int) as begin    declare @PWOsToFill QBM_YParameterlist   BEGIN TRY          2       delete  @PWOsToFill  insert into @PWOsToFill (Parameter1, Parameter2) select p.uid_parameter, p.GenprocID from QBMDBQueueCurrent p with (readpast3) join personwantsorg pwo on p.uid_parameter = pwo.uid_personwantsorg where p.SlotNumber = @SlotNumber exec QER_PITShopPersonHasObjFill_b @PWOsToFill END4 TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 5