Re: reading an external file

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 protected].