Back to OIM Explorer

dbo.QBM_PTElementsReferenced_S

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 960 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.QBM_PTElementsReferenced_I source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL45 lines
1CREATE PROCEDURE QBM_PTElementsReferenced_S(2  @StartElement varchar(138),3  @SameModule BIT = 1,4  @TopDown BIT = 1,5  @ExcludeDS BIT = 06)7AS8BEGIN9  DECLARE @StartElements QBM_YParameterList10  SET XACT_ABORT OFF11  BEGIN TRY12    SET nocount13      ON drop TABLE14    IF EXISTS #QBMCollectorReferenceElements15    CREATE TABLE #QBMCollectorReferenceElements(16      TableName varchar(30) collate database_default,17      Objectkey varchar(138) collate database_default,18      XMarkedForDeletion int,19      SortOrder int DEFAULT 0,20      IsInsertRestrict BIT DEFAULT 0,21      IsDeleteRestrict BIT DEFAULT 0 primary key(ObjectKey)22    )23    INSERT INTO @StartElements(Parameter124  )25  SELECT @StartElement26  EXEC QBM_PTElementsReferenced_I @StartElements,27    @SameModule,28    @TopDown,29    @ExcludeDS30END TRY31BEGIN CATCH32  EXEC QBM_PSessionErrorAdd DEFAULT33  DECLARE @Rethrow varchar(100034) = dbo.QBM_FGISessionErrorRethrow(35)36RAISERROR(@Rethrow,3718,38139)40  WITH NOWAIT41END CATCH42endLabel:43SELECT *44FROM #QBMCollectorReferenceElements45END
Open raw exported source
SQL ยท Raw8 lines
1   create   procedure QBM_PTElementsReferenced_S (@StartElement varchar(138) , @SameModule bit = 1 , @TopDown bit = 1 , @ExcludeDS bit = 0 ) as 2begin declare @StartElements QBM_YParameterList SET XACT_ABORT OFF BEGIN TRY set nocount on drop table if exists #QBMCollectorReferenceElements create 3table #QBMCollectorReferenceElements (TableName varchar(30) collate database_default , Objectkey varchar(138) collate database_default , XMarkedForDeletion4 int , SortOrder int default 0 , IsInsertRestrict bit default 0 , IsDeleteRestrict bit default 0 primary key (ObjectKey) ) insert into @StartElements(Parameter15) select @StartElement exec QBM_PTElementsReferenced_I @StartElements, @SameModule, @TopDown, @ExcludeDS END TRY BEGIN CATCH exec QBM_PSessionErrorAdd 6default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH endLabel:   select * from #QBMCollectorReferenceElements7 end 8