Re: Re: reading an external file
| Newsgroups | gmane.comp.db.oracle.devel |
|---|---|
| Message-ID | <LYRIS-1796914-863946-2003.02.06-17.06.04--gcdod-oracle#[email protected]> |
One more thing : with the UTL file utitlity of oracle 8i you could only read files on local discs. Mapped network drives where not accessible... I don't know if this changed in 9i X ------------------------ "Oracle" <[email protected]> wrote: ------------------------ >You can read an external file, you need to make sure you add a line to the >INIT.ORA file that will be the access path to those files. > >EXAMPLES: > >A single directory: >UTL_FILE_DIR=/kuepper2/conslutling/csc/tobt >Mulitple Directories: >UTL_FILE_DIR=(/kuepper2/consulting/csc/tobt,/tmp,/usr/users/leng) >Any directory that the Oracle owner has read or write permissions: >UTL_FILE_DIR=* > > >After you add this to the INIT.ORA file you can use the UTL_FILE >procedures. >> Hi! > >> I am working on an EDI situation, and I need PL/Sql to read data from a >f> ile (.txt for example) which is external to the Oracle databases. The >P> l/Sql would then INSERT into the tables. I can't figure out how to get >t> his to work, I keep getting a 'table not found' error. Any ideas? > >> Thanks, >G> reg >g> [email protected] >--- >Change your mail options at http://p2p.wrox.com/manager.asp or >to unsubscribe send a blank email to %%email.unsub%%. > --- Change your mail options at http://p2p.wrox.com/manager.asp or to unsubscribe send a blank email to [email protected].