BBC.SHARED.VARA@SEC_SQLI.GET-OBJECT-SUBTYPE
Description
Details
Property | Value |
---|---|
Type | VARA |
Folder | PACKAGES/BEST-BLU/BBC.SHARED/SOURCE/DATA |
Title | Retrieves the sub-type of an object |
Archive Key 1 | - |
Archive Key 2 | - |
Created | Andreas Büsching am: 2022-07-03 16:24:07 |
Last Modified | Andreas Büsching am: 2025-07-04 17:07:36 3 x |
Last Used | - |
SQL
- Statement (MS SQL)
- SELECT OH_Name "Name", OH_OType As "Type", OH_SubType AS "Sub Type"FROM OHWHERE OH_Client = ?AND OH_Name = ?AND OH_DeleteFlag = 0
- Statement (Oracle)
- SELECT OH_Name "Name", OH_OType As "Type", OH_SubType AS "Sub Type"FROM OHWHERE OH_Client = ?AND OH_Name = ?AND OH_DeleteFlag = 0
Result Format :
Bind Parameters
Number | Parameter |
---|---|
1 | &$CLIENT# |
2 | &BBCF_OBJECT_I# |
Attributes
Data & Formatting
- Data Type
- TEXT
- Force Upper Case
- ❌
Script Access
- If key not found
- INITIAL_VALUES