Call a remote procedure via a database link.
create or replace procedure P1(p_ret_code IN OUT varchar2)ASBEGIN p_ret_code:='000';exception when others then p_ret_code:='999';end P1;/set serveroutput on;declare p varchar2(10);begin p1@link_xxx(p); dbms_output.put_line('return:'||p);exception when others then dbms_output.put_line('error:'||p);end;/[@more@]