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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Text-file

Re: Text-file

From: s Lehaire <s.lehaire_at_meilleuregestion.com>
Date: Thu, 28 Nov 2002 17:59:03 +0100
Message-ID: <as5h8l$b9r$1@reader1.imaginet.fr>

"s Lehaire" <s.lehaire_at_meilleuregestion.com> a écrit dans le message de news: as55kv$78a$1_at_reader1.imaginet.fr...
> Hi,
> I know that is possible to write into a file the resultset of a query with
> the spool option.
> but is it possible to read a text file to put the data into a table ?
> Thx for response
> ++
>
>

Ok I found a solution but i've got a probleme: I found the UTL_FILE package but I can't read my file because oracle is not authorized to acces thie directory
so I must add this directory in the init.ora file config but I don't know how to do.
please help =) Received on Thu Nov 28 2002 - 10:59:03 CST

Original text of this message

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