Error in remap_data function ORA-06553: PLS-306
Hello,
I have a requirement to mask some data while moving tables into another database.
If I have a row in the source database as such:
fname=abcd
ID (PrimaryKey) = 1
The transform function I have below here is supposed to take the ID and concatenate it with the word 'User' so it appears as User_1, User_2 and etc in the target database.
create or replace package schema.remap_function as
function remap_fname3 (FNAME in nvarchar2, ID in number) return nvarchar2;
end;
/
create or replace package body schema.remap_function as
function remap_fname3 (FNAME in nvarchar2, ID in number) return nvarchar2