Get job ID from inside DBMS_DATAPUMP.DATA_REMAP function
I am looking to assign column values on an import but cannot seem to figure out how to pass data to the remap function. It only accepts one parameter, and it can't see the value that I have assigned the package variable. I can only assume the import happens in a different session.
ct_pool_pkg.variable := 'TEST';
dbms_datapump.DATA_REMAP(
handle => x_dp_handle,
name => 'COLUMN_FUNCTION',
table_name => 'INSURANCE_AUD',
column => 'EVENT_ID',
function => 'CT_POOL_PKG.ECHO_TEST_VALUE'
);
Assuming there is a function that RETURNS ct_pool_pkg.variable, the result is always NULL.