有out參數(shù)這么調(diào)用？為什么我這樣調(diào)用出錯(cuò)
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;
/
2021-05-14
調(diào)用的時(shí)候要用=> 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;
2019-08-08
調(diào)用方式不對
2019-07-20
begin和后面的分2行