SQL & PL/SQL

declare
cursor cur is 
select object_name from all_objects where OWNER 'HR';
 
var all_objects.object_name%TYPE;
 
begin
open cur;
loop
fetch cur into var;
exit when cur%notfound;
grant SELECT var to SCOTT;
end loop;
close cur;
end;
 
 

what to change?

i want scott to own all object of hr.ora-006550 error on line 1 and pls-00103 error what to do?

Edited by: new2appsdba on Jul 28, 2010 6:06 AM