FreeLists / oracle-l / RE: UTL_FILE ERROR Invalid Filehandle

["Smith, Ron L." <rlsmith@xxxxxxx>]

I am running Oracle 8.1.6 (I know...) on MS NT.  The error message is
just that "UTL_FILE ERROR Invalid Filehandle".

Here is the UTL_FILE info:

-- define file location
    v_report_file_path          :=3D 'd:\data\AP_Interface\Reports';
    -- define file name
    v_report_file_name          :=3D 'STARS Check Request Interface
Report.txt';
    -- initialize file record
    v_report_file_rec           :=3D '';
    v_line                      :=3D ' ';

Like I said.  That part didn't change.

Thanks!
Ron

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Powell, Mark D
Sent: Thursday, July 01, 2004 9:19 AM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: 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
-----------------------------------------------------------------
----------------------------------------------------------------
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
-----------------------------------------------------------------