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

2012-02-22

创建存储过程为什么报错啊？SQL create or replace procedure wcm_anly as2begin2analyze table chnldoc c

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

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