RE: DBMS_STATS Error

From: Ignizio, Richard <richard.ignizio_at_PaeTec.com>
Date: Mon, 24 Oct 2005 10:15:10 -0400
Message-ID: <D63E582D09D77648A106C164FC7C483203C3CB41@mail1-corp.corp.paetec.com>

There is no need for a declare or an Execute:

1 begin
2 dbms_stats.gather_table_stats(ownname=>'XXX',tabname=>'XXX',partname=>NULL); 3* end;

PL/SQL procedure successfully completed.

What version of Oracel are you running?

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Michael.Coll-Barth_at_VerizonWireless.com Sent: Monday, October 24, 2005 9:55 AM
To: oracle-l_at_freelists.org
Subject: RE: DBMS_STATS Error

Deepak,

Try sticking a 'DECLARE' statement before your pl/sql block.

Michael

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of DBA Deepak Sent: Monday, October 24, 2005 9:41 AM
To: oracle-l_at_freelists.org
Subject: DBMS_STATS Error

Hi All,

Getting error while executing the following...

SQL> begin
2 dbms_stats.gather_table_stats(ownname=> 'USER01', tabname=> 'MY_TBL', partname=> NULL); 3 end;
4 /
begin
*
ERROR at line 1:

ORA-06521: PL/SQL: Error mapping function 
ORA-06512: at "SYS.DBMS_STATS", line 9643 
ORA-06512: at "SYS.DBMS_STATS", line 9657 
ORA-06512: at line 2

Any pointers to the problem...?

--

Regards,

Deepak
Oracle DBA

--

http://www.freelists.org/webpage/oracle-l Received on Mon Oct 24 2005 - 09:27:57 CDT