ANALYZE in a stored procedure

From: Michael G. Schneider <mgs_at_mgs-software.de>
Date: Thu, 6 Jan 2000 11:08:54 +0100
Message-ID: <851pnk$8ab$1@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 - 04:08:54 CST