当前位置: 代码迷 >> Oracle管理 >> 创建存储过程为什么报错啊解决思路
  详细解决方案

创建存储过程为什么报错啊解决思路

热度:48   发布时间:2016-04-24 05:41:47.0
创建存储过程为什么报错啊?
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
  相关解决方案