PLS-00103: 出现符号 在需要下列之一时： := . ( @ % ;

SQL> edit
Wrote file afiedt.buf

  1  begin
  2  for i in 1..10000 loop
  3      exec cbc_tt_select();
  4  end loop;
  5* end;
SQL> /
    exec cbc_tt_select();
         *
ERROR at line 3:
ORA-06550: line 3, column 10:
PLS-00103: Encountered the symbol "CBC_TT_SELECT" when expecting one of the
following:
:= . ( @ % ;
The symbol ":=" was substituted for "CBC_TT_SELECT" to continue.


去掉其中的exec就可以了。
SQL> begin
  2  for i in 1..10000 loop
  3  cbc_tt_select();
  4  end loop;
  5  end;
  6  /

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24237320/viewspace-1818227/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24237320/viewspace-1818227/