创建存储过程
SQL> CREATE OR REPLACE PROCEDURE A(I OUT VARCHAR2,
  2                                J IN NUMBER,
  3                                K IN VARCHAR2) AS
  4  BEGIN
  5    I := TO_CHAR(J) || K;
  6  END;
  7  /
 
 Procedure created

方法1
在块中执行 
 SQL> SET SERVEROUTPUT ON
 SQL>
 SQL> DECLARE
  2  v_i VARCHAR2(2000);
  3  BEGIN
  4  A(v_i,123,'ABC');
  5  DBMS_OUTPUT.put_line(v_i);
  6  END;
  7  /
 
 123ABC
 
 PL/SQL procedure successfully completed

方法2
  定义会话变量 v_i
  SQL>variable v_i varchar2(2000);
  SQL>execute A(:v_i,123,'ABC');
  SQL>print v_i;
  也可以用CALL 用CALL替换EXECUTE.

 带IN OUT的参数存储执行 (exec即execute的缩写)
  var name varchar2(100);
  var tel varchar2(100);
  exec :name:=xiaoming;
  exec :tel:=130659465416;
  exec procedure(:name,:tel);
  print name,tel