ORA-06550错误

[biaozon]

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;

[biaozon]

不好意了，没分了。
declare
v_deptno dept.deptno%type;
v_name dept.dname%type;
这里就定义了。

[秋雨飘落]

v_dname:='&name';
v_deptno:=&no;
问题出在这里，变量赋值不能这么做；

select 1,2 into v_name,v_deptno from dept

[秋雨飘落]

2.操纵数据
2.1使用VALUES子句插入数据
v_deptno dept.deptno%type;
v_dname dept.dname%type;
v_deptno:=no; v_dname:='&name';
insert into dept (deptno,dname) values(v_deptno,v_dname);

[ssqtjffcu]

--帮你改好了
declare
  v_deptno dept.deptno%type;
  v_dname   dept.dname%type;
begin
  v_deptno := &no;
  v_dname  := '&name';
  insert into dept (deptno, dname) values (v_deptno, v_dname);
  commit;
end;
/

[psufnxk2008]

[Quote=引用楼主 biaozon 的回复:]
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;
/

运行结……
[/Quote]

名字不一样哦。。

[秋雨飘落]

v_dname v_deptno 这2个变量定义了吗。。