PLS-00103: 出現符號 在需要下列之一時: := . ( @ % ;

tolilong發表於2015-10-29

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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章