Database Utilities (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center