Use the new directory feature of 9i
CREATE OR REPLACE DIRECTORY ROOT
AS
'C:\';
Then pass 'ROOT' where utl_file needs a location. And remove your offending=
entries from init.ora
Btw I really would recommend considering using a folder structure rather th=
an just working directly at c:\ .=20
Niall Litchfield
Oracle DBA
Audit Commission
+44 117 975 7805=20
> -----Original Message-----
> From: maryann_30_at_yahoo.com=20
> Sent: 18 February 2004 00:10
> To: maryann_30_at_yahoo.com; oracle-l_at_freelists.org
> Subject: Re: UTL_File -- invalid path error
>=20
>=20
> this is so frustrating... I tried all the following
>=20
> C:\\ oracle starts but value in v$parameter shows=20
> exactly as c:\\
> and I get invalid path exception
>=20
> c:\ oracle does not start shared memory realm does not exist
> 'c:\' same
> "c:\" same
> "c:\\" same
>=20
> I'm running 9i under xp, I remember this used to work with 8i,
> I was using c:\\ there and it was working ok.
>=20
> At this point I'm ready to try anything else someone might think
> it'll work.
>=20
>=20
>=20
> At 12:24 PM 2/15/2004, you wrote:
> >Check if the instance is started with those init files,
> >with the command,
> >SQL> show parameters utl_file_dir
> >and restart the instance if you don't find the utl file=20
> directories here.
> >
> >If it doesn't solve the problem, check if you can change the
> >init entry to one of the below:
> >utl_file_dir=3Dc:\
> >utl_file_dir=3Dc:
> >and restart the instance.
> >Thanks,
> >Krishna
> >
> >
> >
> >Maryann Atkinson wrote:
> > > Would anyone happen to know why the code below the dashed line
> > > gives as error the following 3 lines?
> > >
> > > > Right before opening the file
> > > > Invalid Path Error 1 User-Defined Exception
> > > > PL/SQL procedure successfully completed.
> > >
> > > Both my
> > > C:\oracle\admin\Oracle9i\pfile\init.ora as well as my
> > > C:\oracle\admin\Ora9i\pfile\init.ora
> > >
> > > files, have the line:
> > >
> > > utl_file_dir=3Dc:\\
> > > somewhere towards the bottom...
> > >
> > > thx
> > > maa
> > >
> > >=20
> >
> --------------------------------------------------------------
> -----------------------------------------------------------
> > > DECLARE
> > > InFile UTL_FILE.File_Type;
> > > InputLine VARCHAR2(1022);
> > >
> > > BEGIN
> > > dbms_output.put_Line('Before Opening the file');
> > >
> > > InFile :=3D UTL_FILE.FOPEN('C:\', 'FILEIO.TXT', 'R');
> > >
> > > DBMS_Output.Put_Line('After the FileOpen');
> > >
> > >
> > > LOOP
> > > BEGIN
> > > UTL_FILE.GET_LINE(InFile, InputLine);
> > >
> > > DBMS_Output.Put_Line(InputLine);
> > >
> > > EXCEPTION
> > > WHEN NO_DATA_FOUND THEN EXIT;
> > > END;
> > > END LOOP;
> > >
> > > UTL_FILE.FCLOSE(InFile);
> > >
> > > DBMS_Output.Put_Line('Execution Ends.');
> > >
> > > EXCEPTION
> > > WHEN UTL_File.Invalid_Path THEN
> > > DBMS_Output.Put_Line('Invalid Path Error '
> > > || TO_CHAR(SQLCODE)
> > > || ' ' || SQLErrM);
> > > WHEN UTL_File.Invalid_Mode THEN
> > > DBMS_Output.Put_Line('Invalid Mode Error '
> > > || TO_CHAR(SQLCODE)
> > > || ' ' || SQLErrM);
> > > /**/
> > > WHEN UTL_File.Invalid_Operation THEN
> > > DBMS_Output.Put_Line('Invalid Operation Error '
> > > || TO_CHAR(SQLCODE)
> > > || ' ' || SQLErrM);
> > > WHEN UTL_File.Internal_Error THEN
> > > DBMS_Output.Put_Line('Internal Error '
> > > || TO_CHAR(SQLCODE)
> > > || ' ' || SQLErrM);
> > > WHEN OTHERS THEN
> > > DBMS_Output.Put_Line('Error ' || To_Char(SQLCODE)
> > > || ' ' || SQLErrM);
> > > END;
> > > /
> > >
> >
> >
> >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> >NOTICE: This email message is for the sole use of the intended
> >recipient(s) and may contain confidential and privileged
> >information. Any unauthorized review, use, disclosure or
> >distribution is prohibited. If you are not the intended
> >recipient, please contact the sender by reply email and destroy
> >all copies of the original message.
> >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> >
> >----------------------------------------------------------------
> >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
> >-----------------------------------------------------------------
>=20
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
>=20
>=20
This email contains information intended for
the addressee only. It may be confidential
and may be the subject of legal and/or
professional privilege. Any dissemination,
distribution, copyright or use of this
communication without prior permission of
the sender is strictly prohibited.
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 Wed Feb 18 2004 - 03:20:31 CST