Transfering variable of UROWID over DB Link

Lets

connect u2/u2@db2

then

create function CLM_161068(xr_id urowid) return urowid

as

begin

  return xr_id;

end;

/

and check how it works locally

SQL> select CLM_161068(rowid) rid_dual,CLM_161068('AAAAECAABAAAAgiAAA') rid_char from dual;

RID_DUAL RID_CHAR

------------------ ------------------

AAAAECAABAAAAgiAAA AAAAECAABAAAAgiAAA

So the result is - expected values

Now lets check how it works remotelly (u2_db2 is link from db1 to db2 as u2)

SQL> connect u1/u1@db1

Connected.

SQL> select CLM_161068@u2_db2(x.rowid) rid_dual,CLM_161068@u2_db2('AAAAECAABAAAAgiAAA') rid_char from dual x;

RID_DUAL RID_CHAR

------------------ ------------------