Back to OIM Explorer

dbo.QER_PPickedItemInsert

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 492 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_PPickedItemInsert_b source text reference

References

Referenced By

Complete Source

SQL25 lines
1CREATE PROCEDURE QER_PPickedItemInsert(2  @UID_QERPickCategory varchar(38),3  @ObjectKeyItem varchar(138)4)5AS6BEGIN7  DECLARE @Items QBM_YParameterList8  SET XACT_ABORT OFF9  BEGIN TRY10    INSERT INTO @Items(Parameter1)11    SELECT @ObjectKeyItem12    EXEC QER_PPickedItemInsert_b @UID_QERPickCategory,13      @Items14  END TRY15  BEGIN CATCH16    EXEC QBM_PSessionErrorAdd DEFAULT17    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()18    RAISERROR(@Rethrow,19    18,20    1)21      WITH NOWAIT22  END CATCH23  endLabel:24  RETURN25END
Open raw exported source
SQL ยท Raw5 lines
1  create   procedure QER_PPickedItemInsert (@UID_QERPickCategory varchar(38) , @ObjectKeyItem varchar(138) ) as begin declare @Items QBM_YParameterList2 SET XACT_ABORT OFF BEGIN TRY insert into @Items(Parameter1) select @ObjectKeyItem exec QER_PPickedItemInsert_b @UID_QERPickCategory, @Items END TRY BEGIN3 CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END 4CATCH  endLabel: return end 5