Retrieve any column from any table#
Functionality:#
This function retrieves a column value from a table
Parameters:#
TABLE_NAME | Either the full table name (e.g. P2K_HR_IDENTITIES) or the table alias (e.g. EID) |
COLUMN_NAME | The column name from that table that you wish to retrieve |
REFERENCE_ID | The ID of the record that you are seeking the data for |
Returns: #
Varchar2 (regardless of the type of data being requested)
Errors: #
- *bad table name* When there is no table found in IMTD with the name, or alias provided
- *bad column name* When there is no column name found in IMCD with that name, for the table provided.
- *error: invalid column length* When the column is a BLOB, or has a maximum length in excess of 4,000 characters
- *error: ORA-xxx is issued when any other error occurs.
Example: #
P2K_PU.GC('EID','FIRST_NAME',~) - Using Identity ID as the third parameter (~)
- Will return the First Name the employee from P2K_HR_IDENTITIES, identified by the ID in the third parameter
Click to create a new notes page
Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor
All content © High Line Corporation