Home » SQL & PL/SQL » SQL & PL/SQL » Cursor throwing error while passing to dbms_stats.gather_schema_stats
Cursor throwing error while passing to dbms_stats.gather_schema_stats [message #677918] Tue, 22 October 2019 14:23 Go to previous message
chavva.kiru@gmail.com
Messages: 15
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;
/
 
Read Message
Read Message
Read Message
Read Message
Previous Topic: Two digit decimal
Next Topic: Multiple Out Parameters Function in Select Statement - Oracle
Goto Forum:
  


Current Time: Fri Jan 17 16:28:45 CST 2020