读书人

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

发布时间: 2012-02-22 19:36:55 作者: rapoo

创建存储过程为什么报错啊?
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

读书人网 >oracle

热点推荐