Back to OIM Explorer

dbo.QER_PITShopProductNodeCreate

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 675 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_PITShopProductNodeCreate_b source text reference

References

Referenced By

Complete Source

SQL31 lines
1CREATE PROCEDURE QER_PITShopProductNodeCreate(2  @uid_orgBO varchar(38),3  @ObjectKeyElement varchar(138),4  @GenProcID varchar(38),5  @uid_OrgPR varchar(38) OUTPUT6)7AS8BEGIN9  DECLARE @ObjectKeys QBM_YParameterList,10  @uid_OrgPR_intern varchar(38)11  SET XACT_ABORT OFF12  BEGIN TRY13    INSERT INTO @ObjectKeys(Parameter1)14    SELECT @ObjectKeyElement15    EXEC QER_PITShopProductNodeCreate_b @uid_orgBO,16      @ObjectKeys,17      @GenProcID,18      @uid_OrgPR_intern OUTPUT19  END TRY20  BEGIN CATCH21    EXEC QBM_PSessionErrorAdd DEFAULT22    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()23    RAISERROR(@Rethrow,24    18,25    1)26      WITH NOWAIT27  END CATCH28  ende:29  SELECT @uid_OrgPR = @uid_OrgPR_intern30  RETURN31END
Open raw exported source
SQL ยท Raw6 lines
1     create   procedure QER_PITShopProductNodeCreate( @uid_orgBO varchar(38) , @ObjectKeyElement varchar(138) , @GenProcID varchar(38) , @uid_OrgPR2 varchar(38) output ) AS begin declare @ObjectKeys QBM_YParameterList , @uid_OrgPR_intern varchar(38) SET XACT_ABORT OFF BEGIN TRY insert into @ObjectKeys3 (Parameter1) select @ObjectKeyElement exec QER_PITShopProductNodeCreate_b @uid_orgBO, @ObjectKeys, @GenProcID, @uid_OrgPR_intern output END TRY BEGIN 4CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH5  ende:  select @uid_OrgPR = @uid_OrgPR_intern return end 6