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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Smith, Ron L.
Sent: Thursday, July 01, 2004 10:07 AM
To: oracle-l@xxxxxxxxxxxxx
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
----------------------------------------------------------------
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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: