dbo.QBM_PSessionContextSet
Stored ProcedureSQL_STORED_PROCEDURESandbox DB
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_FGIGuidIsValid source text reference
- references source dbo.QBM_FGISessionErrorRethrow source text reference
- references source dbo.QBM_PSessionErrorAdd source text reference
References
Referenced By
- dbo.ADS_ZGroupInADSGroup
- dbo.ATT_PAttestationHelperFill
- dbo.ATT_ZAttestationCheckValid
- dbo.ATT_ZAttestationObjectPreProp
- dbo.ATT_ZAttestationReminder
- dbo.ATT_ZAttestationReset
- dbo.ATT_ZAttestationWzParmPreProp
- dbo.CPL_PSubRuleFillPerson_i
- dbo.CPL_ZITShopMakeDecisionCR
- dbo.CPL_ZITShopMakeDecisionOC
- dbo.CPL_ZITShopMakeDecisionOH
- dbo.CPL_ZSubRuleFillObject
- dbo.LDP_ZGroupInLDAPGroup
- dbo.POL_ZQERPolicyFill
- dbo.QBM_PColumnCheckBlobExternal
- dbo.QBM_PDBQCS_CurrentRestore
- dbo.QBM_PDBQCS_SlotExec
- dbo.QBM_PDBQCS_SlotRunner
- dbo.QBM_PDBQCS_WaitJobReset
- dbo.QBM_PDBQueueActivityDisable
- dbo.QBM_PDBQueueCalculateDelta
- dbo.QBM_PDBQueueCompress
- dbo.QBM_PDBQueueExternalTaskFire
- dbo.QBM_PDBQueueInsert_Bulk
- dbo.QBM_PDBQueueInsert_Int
- dbo.QBM_PDialogColumnDelete
- dbo.QBM_PDialogColumnInsert
- dbo.QBM_PDialogUserInGroupCorrect
- dbo.QBM_PDynamicUserForPerson
- dbo.QBM_PExecuteSQLMulti
- dbo.QBM_PJobCreate
- dbo.QBM_PJobQueueInit_i
- dbo.QBM_PJobQueueLoad
- dbo.QBM_PJobqueueoverViewFill
- dbo.QBM_PJobQueueStatsShrink
- dbo.QBM_PMigrationNotReadyForComp
- dbo.QBM_PMNTableDelete
- dbo.QBM_PMNTableInsert
- dbo.QBM_PMNTableInsertOwnPK
- dbo.QBM_PMNTableOriginUpdate
- dbo.QBM_PProcedureDrop
- dbo.QBM_PQBMServerHasJobService
- dbo.QBM_PScheduleCheck
- dbo.QBM_PScheduleStartJob
- dbo.QBM_PSessionErrorClean
- dbo.QBM_PSessionErrorSave
- dbo.QBM_PTableStatistics
- dbo.QBM_PTempQueueEnd
- dbo.QBM_PUserDetectByGroupList
- dbo.QBM_PWatchDogPrepare
- dbo.QBM_PWorkDBQueueDelete
- dbo.QBM_PWorkHistoryDelete
- dbo.QBM_PWorkJobQueueDelete
- dbo.QBM_PWorkMaintenance
- dbo.QBM_PWorkSchedule
- dbo.QBM_PXDateSubItemUpdate
- dbo.QBM_ZCalendarFill
- dbo.QBM_ZCountryUTCOffset
- dbo.QBM_ZDashBoardContentCalculate
- dbo.QBM_ZDialogSemaphorIncAll
Complete Source
1CREATE PROCEDURE QBM_PSessionContextSet(2 @Key varchar(30),3 @Value varchar(1000)4)5AS6BEGIN7 DECLARE @Key_intern varchar(30) = upper(@key)8 DECLARE @Value_intern varchar(1000)9 SET XACT_ABORT OFF10 BEGIN TRY11 IF @Key_intern = 'GENPROCID'12 BEGIN13 IF dbo.QBM_FGIGuidIsValid(@Value) <> 1 AND NOT trim(isnull(@Value, '')) = ''14 BEGIN15 SELECT @Value = newid()16 END17 END18 SELECT19 @Value_intern = isnull(@Value,20 '')21 EXEC sp_set_session_context @Key_intern,22 @Value_intern23 END TRY24 BEGIN CATCH25 EXEC QBM_PSessionErrorAdd DEFAULT26 DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()27 RAISERROR(@Rethrow,28 18,29 1)30 WITH NOWAIT31 END CATCH32 ende:33 RETURN34ENDOpen raw exported source
1 create procedure QBM_PSessionContextSet (@Key varchar(30) , @Value varchar(1000) ) as begin declare @Key_intern varchar(30) = upper(@key) declare2 @Value_intern varchar(1000) SET XACT_ABORT OFF BEGIN TRY if @Key_intern = 'GENPROCID' begin if dbo.QBM_FGIGuidIsValid(@Value) <> 1 and not trim(isnull3(@Value, '')) = '' begin select @Value = newid() end end select @Value_intern = isnull(@Value, '') EXEC sp_set_session_context @Key_intern, @Value_intern4 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH5 NOWAIT END CATCH ende: return end 6