UTL_FILE ERROR Invalid Filehandle

From: Smith, Ron L. <rlsmith_at_kmg.com>
Date: Thu, 1 Jul 2004 09:07:07 -0500
Message-ID: <270A0BDDFDE54E41B78F0F06D82A66B8508C45@okcexg3.kmg.com>

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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Thu Jul 01 2004 - 09:06:28 CDT