BBC.SHARED.VARA.GET-EMAIL-ADDRESS@SEC_SQLI

Summary

Object type
VARA
Object Folder
PACKAGES/BEST-BLU/BBC.SHARED/SOURCE
Title
Retrieves the email address of the current user
Archive Key 1
-
Archive Key 2
-
Created
Andreas Büsching am: 2020-12-22 09:59:35
Last Modified
Andreas Büsching am: 2021-02-02 17:09:44 22 x
Last Used
-

SQL

Statement (MS SQL)
SELECT USR_EMail1 AS “Mail Address” FROM oh JOIN usr ON oh_idnr = USR_OH_Idnr WHERE OH_Name = ? AND OH_Client = ?
Statement (Oracle)
SELECT USR_EMail1 AS “Mail Address” FROM oh JOIN usr ON oh_idnr = USR_OH_Idnr WHERE OH_Name = ? AND OH_Client = ?
Result Format

Bind Parameters

Number Parameter
1 &$USER#/&$DEPARTMENT#
2 &$CLIENT#

Attributes

Data & Formatting

Data Type
TEXT
Force Upper Case

Script Access

If key not found
INITIAL_VALUES