Back to OIM Explorer

dbo.QBM_ZDashBoardDefine

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 622 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_PDashBoardDefine source text reference
  • references source dbo.QBM_PDBQueueCurrentResetNGen source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL37 lines
1CREATE PROCEDURE QBM_ZDashBoardDefine(2  @SlotNumber int,3  @UID_DialogDashboardDef varchar(38),4  @dummy1 varchar(38),5  @GenProcID varchar(38)6)7AS8BEGIN9  DECLARE @ResetMessage nvarchar(4000)10  BEGIN TRY11    BEGIN TRY12      EXEC QBM_PDashBoardDefine @UID_DialogDashboardDef,13        @GenProcID,14      015    END TRY16    BEGIN CATCH17      EXEC QBM_PSessionErrorAdd DEFAULT18      SELECT @ResetMessage = ERROR_MESSAGE()19      IF @@TRANCOUNT > 020      BEGIN21        ROLLBACK22      END23      EXEC QBM_PDBQueueCurrentResetNGen @SlotNumber,24        @ResetMessage,25        @@PROCID26    END CATCH27  END TRY28  BEGIN CATCH29    EXEC QBM_PSessionErrorAdd DEFAULT30    RAISERROR('',31    18,32    1)33      WITH NOWAIT34  END CATCH35  endLabel:36  RETURN37END
Open raw exported source
SQL ยท Raw6 lines
1  create   procedure QBM_ZDashBoardDefine ( @SlotNumber int ,@UID_DialogDashboardDef varchar(38) ,@dummy1 varchar(38) ,@GenProcID varchar(38) ) 2as begin declare @ResetMessage nvarchar(4000) BEGIN TRY BEGIN TRY exec QBM_PDashBoardDefine @UID_DialogDashboardDef , @GenProcID , 0  END TRY BEGIN CATCH3 exec QBM_PSessionErrorAdd default select @ResetMessage = ERROR_MESSAGE() if @@TRANCOUNT > 0 begin rollback end  exec QBM_PDBQueueCurrentResetNGen @SlotNumber4 , @ResetMessage , @@PROCID END CATCH END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: return5 end 6