P 2 K_PU.GC
Back to current versionRestore this version

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: #

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

Notes#

Click to create a new notes page