数据库存储方式出错!!!pts-00103
create or replace procedure mass_rule (maxcountshuxing,maxcountpeople)as
sqlstr varchar2(1024);
shuxing number(9) := 0;
people number(9) := 0;
Rvalue number := 1;
maxshuxing number :=maxcountshuxing;
maxpeople number :=maxcountpeople;
begin
sqlstr := 'delete from BASE_OBJECT ';
execute immediate sqlstr;
commit;
sqlstr := 'delete from BASE_OBJECT_ATTRIBUTE ';
execute immediate sqlstr;
commit;
while people<maxpeople
Loop
sqlstr := 'insert into BASE_OBJECT (Object_ID,OBJECT_NAME)values (SEQ_Base_object.nextval,'111111')';
execute immediate sqlstr;
commit;
people :=people+1;
while shuxing < maxshuxing
Loop
sqlstr := 'insert into BASE_OBJECT_ATTRIBUTE (ATTRIBUTE_ID, OBJECT_ID,DEAL_STATE,attribute_type,attribute_value )values (SEQ_Base_object_attribute.nextval,SEQ_Base_object.currval,0,8,'||to_char(Rvalue)||')';
execute immediate sqlstr;
commit;
Rvalue := Rvalue+1;
shuxing :=shuxing+1;
end Loop;
end Loop;
end;
/
SQL> exec mass_rule{(10000,200000)
begin mass_rule{(10000,200000); end;
ORA-06550: line 2, column 16:
PLS-00103: Encountered the symbol "{" when expecting one of the following:
:= . ( @ % ;
The symbol "{" was ignored.
[解决办法]
这么明显的错误提示呀,多了个{
SQL> exec mass_rule(10000,200000)
[解决办法]
create or replace procedure mass_rule (maxcountshuxing,maxcountpeople)
先不说执行,就这一句能编译通过?
[解决办法]
SQL> exec mass_rule{(10000,200000)
[解决办法]
计算机不是中文的错,要是报中文错,咱就看懂了!
[解决办法]
数据库存储方式出错!pts-00103,该怎么处理
数据库存储方式出错!!!pts-00103create or replace procedure mass_rule (maxcountshuxing,maxcountpeople
