Back to OIM Explorer

dbo.QER_PITShopPersonHasObjectFill

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 585 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_PITShopPersonHasObjFill_b source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL32 lines
1CREATE PROCEDURE QER_PITShopPersonHasObjectFill(2  @uid_Personwantsorg varchar(38),3  @GenProcID varchar(38),4  @IsCalledFromTrigger BIT = 05)6  WITH7EXECUTE8AS9'dbo' AS10BEGIN11  DECLARE @PWOs QBM_YParameterlist12  SET XACT_ABORT OFF13  BEGIN TRY14    INSERT INTO @PWOs(Parameter1,15    Parameter2)16    SELECT17      @uid_Personwantsorg,18      @GenProcID19    EXEC QER_PITShopPersonHasObjFill_b @PWOs,20      @IsCalledFromTrigger21  END TRY22  BEGIN CATCH23    EXEC QBM_PSessionErrorAdd DEFAULT24    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()25    RAISERROR(@Rethrow,26    18,27    1)28      WITH NOWAIT29  END CATCH30  ende: revert31  RETURN32END
Open raw exported source
SQL ยท Raw5 lines
1 create   procedure QER_PITShopPersonHasObjectFill (@uid_Personwantsorg varchar(38) , @GenProcID varchar(38) , @IsCalledFromTrigger bit = 0 ) with2 execute as 'dbo' as begin  declare @PWOs QBM_YParameterlist   SET XACT_ABORT OFF BEGIN TRY insert into @PWOs(Parameter1, Parameter2) select @uid_Personwantsorg3, @GenProcID exec QER_PITShopPersonHasObjFill_b @PWOs, @IsCalledFromTrigger END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar4(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH  ende: revert return end 5