Re: UTL_File -- invalid path error
- From: Maryann Atkinson <maryann_30@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 17 Feb 2004 19:10:41 -0500
this is so frustrating... I tried all the following
C:\\ oracle starts but value in v$parameter shows exactly as c:\\
and I get invalid path exception
c:\ oracle does not start shared memory realm does not exist
'c:\' same
"c:\" same
"c:\\" same
I'm running 9i under xp, I remember this used to work with 8i,
I was using c:\\ there and it was working ok.
At this point I'm ready to try anything else someone might think
it'll work.
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 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=c:\
>utl_file_dir=c:
>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=c:\\
> > somewhere towards the bottom...
> >
> > thx
> > maa
> >
> >
> -------------------------------------------------------------------------------------------------------------------------
> > DECLARE
> > InFile UTL_FILE.File_Type;
> > InputLine VARCHAR2(1022);
> >
> > BEGIN
> > dbms_output.put_Line('Before Opening the file');
> >
> > InFile := 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@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
>-----------------------------------------------------------------
----------------------------------------------------------------
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:
