Hi All, i am so new to plsql. this code has been compiled but it gave a warning. I guess i am missing a small issue like semicolon but since im new i could not see what the problem is.
CREATE OR REPLACE procedure BAKIM.grantt_uguser as
cursor synn is
select 'CREATE PUBLIC SYNONYM '||object_name||' for '||owner||'.'||object_name TXT from dba_objects
where owner= 'FCY' and object_type in ('INDEX','PROCEDURE','TABLE','FUNCTION','VIEW','TRIGGER','SEQUENCE','PACKAGE')
and
object_name not in (select table_name from dba_synonyms where owner = 'FCY');
begin
for li in synn
loop
execute immediate li.TXT;
end loop;
end;
/