SQL> declare
2 type table_dept is table of DepartmentInfo%rowtype index by binary_integer;
3 ta table_dept;
4 n number;
5 begin
6 select * into ta(1) from DepartmentInfo where departmentcode='101';
7 select * into ta(2) from DepartmentInfo where departmentcode='201';
8 select * into ta(3) from DepartmentInfo where departmentcode='301';
9 dbms_output.put_line(ta(1).departmentcode||' '|| ta(1).departmentname);
10 dbms_output.put_line(ta(2).departmentcode||' '|| ta(2).departmentname);
11 dbms_output.put_line(ta(3).departmentcode||' '|| ta(3).departmentname);
12 ta_n=ta.count;
13 dbms_output.put_line('table_dept表共'||ta_n||'行');
14 end;
15 /
ta_n=ta.count;
*
ERROR 位于第 12 行:
ORA-06550: 第 12 行, 第 5 列:
PLS-00103: 出现符号 "="在需要下列之一时:
:=.(@%;
2 type table_dept is table of DepartmentInfo%rowtype index by binary_integer;
3 ta table_dept;
4 n number;
5 begin
6 select * into ta(1) from DepartmentInfo where departmentcode='101';
7 select * into ta(2) from DepartmentInfo where departmentcode='201';
8 select * into ta(3) from DepartmentInfo where departmentcode='301';
9 dbms_output.put_line(ta(1).departmentcode||' '|| ta(1).departmentname);
10 dbms_output.put_line(ta(2).departmentcode||' '|| ta(2).departmentname);
11 dbms_output.put_line(ta(3).departmentcode||' '|| ta(3).departmentname);
12 ta_n=ta.count;
13 dbms_output.put_line('table_dept表共'||ta_n||'行');
14 end;
15 /
ta_n=ta.count;
*
ERROR 位于第 12 行:
ORA-06550: 第 12 行, 第 5 列:
PLS-00103: 出现符号 "="在需要下列之一时:
:=.(@%;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货