带输出的存储过程调用是不是只能通过pl/sql 不能用exec?
------解决思路----------------------
要不参数咋写啊
------解决思路----------------------
百度下可以的~~ 需要先声明定义输出参数
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
Connected as scott@ORCL
SQL>
SQL> create or replace procedure p_out (p_no in number,p_name out varchar2)
2 is
3 begin
4 select ename into p_name from emp where empno=p_no;
5 end;
6 /
Procedure created
SQL> var v_name varchar2;
SQL> exec p_out(7369,:v_name);
PL/SQL procedure successfully completed
v_name
---------
SMITH
SQL>
------解决思路----------------------
都可以,存储过程带输出参数就可以了