Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining optionsSQL> exec literals;
BEGIN literals; END;*
第 1 行出现错误:
ORA-00933: SQL 命令未正确结束
ORA-06512: 在 "SYS.DBMS_SYS_SQL", line 906
ORA-06512: 在 "SYS.DBMS_SQL", line 39
ORA-06512: 在 "BBS.LITERALS", line 9
ORA-06512: 在 line 1过程literals源码:
is
c number;
p number;
x number;
x1 number;
begin
for i in 1..10000 loop
c := dbms_sql.open_cursor;
dbms_sql.parse(c,
'select pid from people'||
'where pid = '||i,dbms_sql.native);
x := dbms_sql.execute(c);
x1 := dbms_sql.fetch_rows(c);
dbms_sql.close_cursor(c);
end loop ;
end;
求解决!!!
With the Partitioning, OLAP and Data Mining optionsSQL> exec literals;
BEGIN literals; END;*
第 1 行出现错误:
ORA-00933: SQL 命令未正确结束
ORA-06512: 在 "SYS.DBMS_SYS_SQL", line 906
ORA-06512: 在 "SYS.DBMS_SQL", line 39
ORA-06512: 在 "BBS.LITERALS", line 9
ORA-06512: 在 line 1过程literals源码:
is
c number;
p number;
x number;
x1 number;
begin
for i in 1..10000 loop
c := dbms_sql.open_cursor;
dbms_sql.parse(c,
'select pid from people'||
'where pid = '||i,dbms_sql.native);
x := dbms_sql.execute(c);
x1 := dbms_sql.fetch_rows(c);
dbms_sql.close_cursor(c);
end loop ;
end;
求解决!!!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货