Hi

I have written the below script to recompile the synonyms in all the schemas but I am getting invalid character error. Could you check is there any wrong with the script:

spool 'c:synonyms.txt'

begin

for i in (select object_name,owner from all_objects
where owner like '&1.%'
and object_type = 'SYNONYM'
and status = 'INVALID')
LOOP
begin
execute immediate 'alter synonym ' || i.owner || '.' || i.object_name || ' compile ; ';
exception when others then
dbms_output.put_line ( 'unable to recompile '||i.owner||'.'||i.object_name||' '||' -ERROR- '||SQLERRM);
end;
end loop;
end;
/

SPOOL OFF.

I am calling the script by passing the variable value.

The error is as below:

unable to recompile BASE_CORE.PARTICIPANT_AWARD -ERROR- ORA-00911: i
nvalid character