OraFAQ Forum: SQL & PL/SQL » Cursor throwing error while passing to dbms_stats.gather_schema

Home » SQL & PL/SQL » SQL & PL/SQL » Cursor throwing error while passing to dbms_stats.gather_schema_stats

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Cursor throwing error while passing to dbms_stats.gather_schema_stats [message #677918]

Tue, 22 October 2019 14:23

chavva.kiru@gmail.com
Messages: 23
Registered: April 2012
Location: hyderabad

Junior Member

Hi,

Below Cursor is throwing error while passing through schema_stats procedure.

error as:Encountered the symbol "DBMS_STATS" when expecting one of the following:=.(@ % The symbol ":=

can any one please help how to rectify below issue

declare
cursor c1 is
select distinct owner from all_tables;
begin
for i in c1
loop
exec dbms_stats.gather_schema_stats(ownname=>i.owner);
end loop;
end;
/

Report message to a moderator

[Message index]

		Cursor throwing error while passing to dbms_stats.gather_schema_stats By: chavva.kiru@gmail.com on Tue, 22 October 2019 14:23
		Re: Cursor throwing error while passing to dbms_stats.gather_schema_stats By: Michel Cadot on Tue, 22 October 2019 14:34
		Re: Cursor throwing error while passing to dbms_stats.gather_schema_stats By: cookiemonster on Wed, 23 October 2019 03:04
		Re: Cursor throwing error while passing to dbms_stats.gather_schema_stats By: Bill B on Thu, 24 October 2019 11:13

Previous Topic:	Two digit decimal
Next Topic:	Multiple Out Parameters Function in Select Statement - Oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 19:48:24 CDT 2024