Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: help on UTL_FILE..

Re: help on UTL_FILE..

From: djordjej <djordjej_at_attcanada.ca>
Date: Mon, 31 Jul 2000 21:17:20 -0400
Message-Id: <10575.113437@fatcity.com> 





This is a multi-part message in MIME format.



------=_NextPart_000_0018_01BFFB34.B61A20A0
Content-Type: text/plain;


        charset="iso-8859-1"


Content-Transfer-Encoding: quoted-printable



Have you rebounced your database after changing the init.ora file ?
-----Original Message-----


    From: Makarand Natu <Makarand.Natu_at_originindia.com>
    To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
    Date: Monday, July 31, 2000 8:59 PM


    Subject: RE: help on UTL_FILE..


   =20


   =20


    Yes, I have modified the init<SID>.ora file to include the parameter =
ULT_FILE_DIR pointing to the mapped dir.=20


    But the problem is still there.=20


   =20


    -----Original Message-----=20

        From:   Dave Drienhuizen [SMTP:nldrien1_at_ey.nl]=20
        Sent:   Monday, July 31, 2000 8:01 PM=20
        To:     Multiple recipients of list ORACLE-L=20
        Subject:        Re: help on UTL_FILE..=20


       =20

       =20

       =20

       =20

        Did you specifiy your directory in the UTL_FILE_DIR parameter in =
the init.ora ?=20


       =20

       =20

       =20

       =20

       =20

       =20

       =20

        Makarand Natu <Makarand.Natu_at_originindia.com> on 31-07-2000 =
14:25:40=20


       =20

        Please respond to ORACLE-L_at_fatcity.com=20


       =20

        To:   Multiple recipients of list ORACLE-L =
<ORACLE-L_at_fatcity.com>=20
        cc:    (bcc: Dave Drienhuizen/nldrien1/External/MEY/NL)=20


       =20

        Hi Gurus,=20


       =20

       =20

       =20

        I'm running Oracle 8.0.5 on NT-4 (SP3) on Server 1.=20
        Server 1 has a mapping E:\   pointing to Server 2\share =
directory.=20
        I'm trying to read a file on E:\ by using UTL_FILE package. But =
is is raising an=20
        INVALID_OPERATION=20
        exception.=20
        I have checked the file access and that is fine. Also the paths =
specified in=20
        UTL_FILE.FOPEN call are correct.=20
        Help requested..=20


       =20

       =20

       =20

        TIA,=20


       =20

       =20

       =20

        Makarand Natu=20


       =20

       =20

       =20

       =20

       =20

       =20

       =20

       =20

       =20

       =20

       =20

       =20

       =20

       =20

        =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20


        De informatie verzonden met dit E-mail bericht is uitsluitend =
bestemd voor=20


        de geadresseerde. Gebruik van deze informatie door anderen dan =
de=20


        geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, =
verspreiding=20


        en/of verstrekking van deze informatie aan derden is niet =
toegestaan.=20


        Ernst & Young staat niet in voor de juiste en volledige =
overbrenging van de=20


        inhoud van een verzonden E-mail, noch voor tijdige ontvangst =
daarvan.=20


        =

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20
        The information contained in this communication is confidential =
and may be=20
        legally privileged. It is intended solely for the use of the =
individual or=20
        entity to whom it is addressed and others authorised to receive =
it. If you=20
        are not the intended recipient you are hereby notified that any =
disclosure,=20
        copying,  distribution or taking any action in reliance on the =
contents of=20
        this information is strictly prohibited and may be unlawful. =
Ernst &=20
        Young is neither liable  for the proper and complete =
transmission of the=20
        information contained in this communication nor for any delay in =
its=20
        receipt.=20
        =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20


       =20

       =20

       =20

       =20


        --=20
        Author: Dave Drienhuizen=20
          INET: nldrien1_at_ey.nl=20


       =20

        Fat City Network Services    -- (858) 538-5051  FAX: (858) =
538-5051=20
        San Diego, California        -- Public Internet access / Mailing =
Lists=20
        =
--------------------------------------------------------------------=20
        To REMOVE yourself from this mailing list, send an E-Mail =
message=20
        to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and =
in=20
        the message BODY, include a line containing: UNSUB ORACLE-L=20
        (or the name of mailing list you want to be removed from).  You =
may=20
        also send the HELP command for other information (like =
subscribing).=20


       =20






------=_NextPart_000_0018_01BFFB34.B61A20A0
Content-Type: text/html;


        charset="iso-8859-1"


Content-Transfer-Encoding: quoted-printable


<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>





<META content=3Dtext/html;charset=3Diso-8859-1 =
http-equiv=3DContent-Type><TITLE>RE: help on UTL_FILE..</TITLE><!DOCTYPE =
HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">


<META content=3D'"MSHTML 4.71.1712.3"' name=3DGENERATOR>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#000000 size=3D2>Have you rebounced your database =


after changing=20


the init.ora file ?</FONT></DIV>


<BLOCKQUOTE=20


style=3D"BORDER-LEFT: #000000 solid 2px; MARGIN-LEFT: 5px; PADDING-LEFT: =
5px">


    <DIV><FONT face=3DArial size=3D2><B>-----Original =
Message-----</B><BR><B>From:=20


    </B>Makarand Natu &lt;<A=20


    =


href=3D"mailto:Makarand.Natu_at_originindia.com">Makarand.Natu_at_originindia.c=
om</A>&gt;<BR><B>To:=20


    </B>Multiple recipients of list ORACLE-L &lt;<A=20

    =
href=3D"mailto:ORACLE-L_at_fatcity.com">ORACLE-L_at_fatcity.com</A>&gt;<BR><B>D=
ate:=20




    </B>Monday, July 31, 2000 8:59 PM<BR><B>Subject: </B>RE: help on=20
    UTL_FILE..<BR><BR></DIV></FONT>


    <P><FONT color=3D#0000ff face=3DArial size=3D2>Yes, I have modified =
the=20


    init&lt;SID&gt;.ora file to include the parameter ULT_FILE_DIR =
pointing to=20


    the mapped dir.</FONT> <BR><FONT color=3D#0000ff face=3DArial =
size=3D2>But the=20


    problem is still there.</FONT> </P>


    <UL>


        <P><FONT face=3DArial size=3D1>-----Original Message-----</FONT> =



        <BR><B><FONT face=3DArial size=3D1>From:&nbsp;&nbsp;</FONT></B> =
<FONT=20


        face=3DArial size=3D1>Dave Drienhuizen =
[SMTP:nldrien1_at_ey.nl]</FONT>=20


        <BR><B><FONT face=3DArial size=3D1>Sent:&nbsp;&nbsp;</FONT></B> =
<FONT=20

        face=3DArial size=3D1>Monday, July 31, 2000 8:01 PM</FONT> =
<BR><B><FONT=20
        face=3DArial size=3D1>To:&nbsp;&nbsp;&nbsp;&nbsp;</FONT></B> =
<FONT=20
        face=3DArial size=3D1>Multiple recipients of list =
ORACLE-L</FONT>=20
        <BR><B><FONT face=3DArial=20
        =
size=3D1>Subject:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</FONT></B>=20
        <FONT face=3DArial size=3D1>Re: help on UTL_FILE..</FONT> =
</P><BR><BR>
        <P><FONT face=3DArial size=3D2>Did you specifiy your directory =
in the=20
        UTL_FILE_DIR parameter in the init.ora ?</FONT> =
</P><BR><BR><BR><BR><BR>
        <P><FONT face=3DArial size=3D2>Makarand Natu=20
        &lt;Makarand.Natu_at_originindia.com&gt; on 31-07-2000 =
14:25:40</FONT> </P>
        <P><FONT face=3DArial size=3D2>Please respond to =
ORACLE-L_at_fatcity.com</FONT>=20
        </P>
        <P><FONT face=3DArial size=3D2>To:&nbsp;&nbsp; Multiple =
recipients of list=20
        ORACLE-L &lt;ORACLE-L_at_fatcity.com&gt;</FONT> <BR><FONT =
face=3DArial=20
        size=3D2>cc:&nbsp;&nbsp;&nbsp; (bcc: Dave=20
        Drienhuizen/nldrien1/External/MEY/NL)</FONT> </P>
        <P><FONT face=3DArial size=3D2>Hi Gurus,</FONT> </P><BR>
        <P><FONT face=3DArial size=3D2>I'm running Oracle 8.0.5 on NT-4 =
(SP3) on=20
        Server 1.</FONT> <BR><FONT face=3DArial size=3D2>Server 1 has a =
mapping=20
        E:\&nbsp;&nbsp; pointing to Server 2\share directory.</FONT> =
<BR><FONT=20
        face=3DArial size=3D2>I'm trying to read a file on E:\ by using =
UTL_FILE=20
        package. But is is raising an</FONT> <BR><FONT face=3DArial=20
        size=3D2>INVALID_OPERATION</FONT> <BR><FONT face=3DArial=20
        size=3D2>exception.</FONT> <BR><FONT face=3DArial size=3D2>I =
have checked the=20
        file access and that is fine. Also the paths specified in</FONT> =

        <BR><FONT face=3DArial size=3D2>UTL_FILE.FOPEN call are =
correct.</FONT>=20
        <BR><FONT face=3DArial size=3D2>Help requested..</FONT> </P><BR>
        <P><FONT face=3DArial size=3D2>TIA,</FONT> </P><BR>
        <P><FONT face=3DArial size=3D2>Makarand Natu</FONT>=20
        </P><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR>
        <P><FONT face=3DArial=20
        =
size=3D2>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</FONT>=20


        <BR><FONT face=3DArial size=3D2>De informatie verzonden met dit =
E-mail=20


        bericht is uitsluitend bestemd voor</FONT> <BR><FONT =
face=3DArial=20


        size=3D2>de geadresseerde. Gebruik van deze informatie door =
anderen dan=20


        de</FONT> <BR><FONT face=3DArial size=3D2>geadresseerde is =
verboden.=20


        Openbaarmaking, vermenigvuldiging, verspreiding</FONT> <BR><FONT =



        face=3DArial size=3D2>en/of verstrekking van deze informatie aan =
derden is=20


        niet toegestaan.</FONT> <BR><FONT face=3DArial size=3D2>Ernst =
&amp; Young=20


        staat niet in voor de juiste en volledige overbrenging van =
de</FONT>=20


        <BR><FONT face=3DArial size=3D2>inhoud van een verzonden E-mail, =
noch voor=20

        tijdige ontvangst daarvan.</FONT> <BR><FONT face=3DArial=20
        =
size=3D2>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</FONT>=20


        <BR><FONT face=3DArial size=3D2>The information contained in =
this=20


        communication is confidential and may be</FONT> <BR><FONT =
face=3DArial=20


        size=3D2>legally privileged. It is intended solely for the use =
of the=20


        individual or</FONT> <BR><FONT face=3DArial size=3D2>entity to =
whom it is=20


        addressed and others authorised to receive it. If you</FONT> =
<BR><FONT=20


        face=3DArial size=3D2>are not the intended recipient you are =
hereby notified=20


        that any disclosure,</FONT> <BR><FONT face=3DArial =
size=3D2>copying,&nbsp;=20


        distribution or taking any action in reliance on the contents =
of</FONT>=20


        <BR><FONT face=3DArial size=3D2>this information is strictly =
prohibited and=20


        may be unlawful. Ernst &amp;</FONT> <BR><FONT face=3DArial =
size=3D2>Young is=20


        neither liable&nbsp; for the proper and complete transmission of =



        the</FONT> <BR><FONT face=3DArial size=3D2>information contained =
in this=20


        communication nor for any delay in its</FONT> <BR><FONT =
face=3DArial=20

        size=3D2>receipt.</FONT> <BR><FONT face=3DArial=20
        =
size=3D2>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</FONT>=20

        </P><BR><BR>
        <P><FONT face=3DArial size=3D2>-- </FONT><BR><FONT face=3DArial =
size=3D2>Author:=20
        Dave Drienhuizen</FONT> <BR><FONT face=3DArial size=3D2>&nbsp; =
INET:=20
        nldrien1_at_ey.nl</FONT> </P>
        <P><FONT face=3DArial size=3D2>Fat City Network =
Services&nbsp;&nbsp;&nbsp;=20
        -- (858) 538-5051&nbsp; FAX: (858) 538-5051</FONT> <BR><FONT =
face=3DArial=20
        size=3D2>San Diego, =
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
        -- Public Internet access / Mailing Lists</FONT> <BR><FONT =
face=3DArial=20
        =
size=3D2>----------------------------------------------------------------=
----</FONT>=20
        <BR><FONT face=3DArial size=3D2>To REMOVE yourself from this =
mailing list,=20
        send an E-Mail message</FONT> <BR><FONT face=3DArial =
size=3D2>to:=20
        ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and =
in</FONT>=20
        <BR><FONT face=3DArial size=3D2>the message BODY, include a line =
containing:=20
        UNSUB ORACLE-L</FONT> <BR><FONT face=3DArial size=3D2>(or the =


Received on Mon Jul 31 2000 - 20:17:20 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US