Can not get dbms_datapump.data_remap to work
I am getting an ORA-39001: invalid argument value error at this call:
dbms_datapump.data_remap (handle => dph,
name => 'COLUMN_FUNCTION',
table_name => mask_tab,
column => mask_col,
function => 'ORA_ADMIN.DATA_MASKER_UTIL.mask_number_random',
schema => 'SCOTT');
My Funtion is:
FUNCTION mask_varchar2 (data_to_mask VARCHAR2) RETURN VARCHAR2 IS
ret_val VARCHAR2(4000);
BEGIN
ret_val := dbms_random.string('U', length(data_to_mask));