This is ddl and ddl is not allowed in pl/sql directly.
You need to call dbms_utility.analyze_object (or dbms_system.analyze_object,
I don't remember).
Hth,
--
Sybrand Bakker, Oracle DBA
Michael G. Schneider <mgs_at_mgs-software.de> wrote in message
news:851pnk$8ab$1_at_ssauraac-i-1.production.compuserve.com...
> Probably a beginner's question. Sorry ...
>
> I want to write a stored procedure, which analyzes the statistics. So I
try
> to write
>
> CREATE OR REPLACE PROCEDURE P_SysCreateStatistik
> AS
> BEGIN
> ANALYZE TABLE tbl COMPUTE STATISTICS;
> END;
> /
> SHOW ERRORS;
>
> But Oracle tells me "found the word TABLE, when one of the following is
> expected ...". The ANALYZE-statement is correct, when being entered in SQL
> Plus directly.
>
> Michael G. Schneider
> mailto:mgs_at_mgs-software.de
>
>
Received on Thu Jan 06 2000 - 05:14:33 CST
