I have a package that reads and write several tables on other databases through dblinks. I changed the tablename/dblinks to public synonyms with dblinks so the package could point to different databases by changing the public synonym instead of the package. The package compiles ok but when I execute it I get the Invalid Filehandle error. None of the code in the package was changed except the table names. None of the UTL_FILE code was changed. I can still run the original code ok but the new copy with the synonyms just won't run. Can anyone tell me what I am missing? Thanks! Ron Smith ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------