创建一个存储过程
create or replace procedure query_employee(eno number,name out varchar2,salary out number)
is
begin
select ename ,sal into name,salary from emp
where empno=eno;
end;执行call query_employee(7788,:name,:salary);报错
create or replace procedure query_employee(eno number,name out varchar2,salary out number)
is
begin
select ename ,sal into name,salary from emp
where empno=eno;
end;执行call query_employee(7788,:name,:salary);报错
SQL> variable salary number;
SQL> exec query_employee(7788,:name,:salary);
declare
v_name emp.ename%type;
v_salary emp.sal%type;
begin
exec query_employee(7788,v_name,v_salary);
dbms_output.put_line(v_name||' '||v_salary);
end;