create or replace procedure information(eno in number,
pename out varchar2,
psal out number,
pjob out varchar2)
as
beginselect ename,sal,empjob into pename,psal,pjob from emp where empno=eno;
end;
/
begin
information(7839);
end;
/
2019-07-19
调用的时候要用=> f赋值：
declare
pstu_id varchar2(256);
pstuname varchar2(256);
page varchar2(256);
pclassid varchar2(256);
begin
pstu_id := 1;
queryimg(pstu_id => pstu_id,
pstuname => pstuname,
page => page,
pclassid => pclassid);
dbms_output.put_line('pstuname=' || pstuname);
dbms_output.put_line('page=' || page);
dbms_output.put_line('pclassid=' || pclassid);
end;
举报
