| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: UTL_FILE ERROR Invalid Filehandle
What version of Oracle?
What platform?
What are the actual Oracle error messages being returned?
Does you code use files located via the utl_file_dir parameter or via a
directory?
The actual lines where the error is triggered from might also be helpful.
IMHO -- Mark D Powell --
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Smith, Ron L.
Sent: Thursday, July 01, 2004 10:07 AM
To: oracle-l_at_freelists.org
Subject: UTL_FILE ERROR Invalid Filehandle
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
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |