PL/SQL (MOSC)

MOSC Banner

Error in remap_data function ORA-06553: PLS-306

edited Mar 31, 2020 5:02AM in PL/SQL (MOSC) 11 commentsAnswered

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

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