日期:2014-05-17  浏览次数:20814 次

创建存储过程为什么报错啊?
SQL> create or replace procedure wcm_anly as 
  2 begin
  2 analyze table chnldoc compute statistics;
  3 analyze index IDX_CHNLdoc_1 compute statistics;
  4 analyze index IDX_CHNLdoc_2 compute statistics;
  5 analyze table document compute statistics;
  6 analyze index IDX_DOC_1 compute statistics;
  7 analyze table dockeyword compute statistics;
  8 analyze index IDX_DOCKEYWORD_1 compute statistics;
  9 end;
 10 /
 
Warning: Procedure created with compilation errors
 
SQL> show error
Errors for PROCEDURE TRSWCMV65.WCM_ANLY:
 
LINE/COL ERROR
-------- ---------------------------------------------------------
2/15 PLS-00103: Encountered the symbol "CHNLDOC" when expecting one of the following:

------解决方案--------------------
探讨
SQL> create or replace procedure wcm_anly as
2 begin
2 analyze table chnldoc compute statistics;
...
end