UTL_FILE ERROR Invalid Filehandle
- From: "Smith, Ron L." <rlsmith@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 1 Jul 2004 09:07:07 -0500
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
-----------------------------------------------------------------
Other related posts:
