关于数据存储的基本问题
create or replace procedure myproc2(id in varchar2,name out varchar2)
is
begin
update work set work.did:='licheng' into name where work.eid=id;
end myproc2;
请问这个update语句正确么
declare
id varchar2(10);
name varchar2(10);
begin
id:='13';
myproc2(id,name);
dbms_output.put_line(name);
end;
我用这个执行语句总是提示myproc2不存在
[解决办法]
update work set work.did:='licheng' into name where work.eid=id;
没这么用的。
update work set work.did:='licheng' where work.eid=id returning work.did into name;
这样子试试