in remote system db create function like,

create or replace function port_string return varchar2 as
lv_port varchar2(2000);
begin
select dbms_utility.port_string
into lv_port
from dual;
return lv_port;
end;
/

Function created.


in local system

SQL> select [Email Address Removed] from dual;

SVR4-be-64bit-8.1.0


Thanks and Regards,
Satheesh Babu.S



Oracle LazyDBA home page