declare
v_deptno dept.deptno%type;
v_name dept.dname%type;
begin
v_dname:='&name';
v_deptno:=&no;
insert into dept(deptno,dname)
values(v_deptno,v_dname)
end;
/
运行结果:
Enter value from name: dept5
old 5: v_dname:="&name";
new 5: v_dname:='dept5';
Enter value for no:5
old 5: no:=&no;
new 5: v_dname:=5;
错误信息:
v_deptno:=5;
*
ORA-06550:line 5 coulumn 12;
...全文
3116打赏收藏
ORA-06550错误
declare v_deptno dept.deptno%type; v_name dept.dname%type; begin v_dname:='&name'; v_deptno:=&no; insert into dept(deptno,dname) values(v_deptno,v_dname) end; / 运行结果: Enter value from name: dept5 old 5: v_dname:="&name"; new 5: v_dname:='dept5'; Ente