RE: reading an external file

If your example (*.txt) is what you are trying to read outside of oracle via
PL/SQL I don't know if you can do this.   You may want to investigate SQL
Loader utility.

-----Original Message-----
From: David, Romeo B. (Govt) [mailto:[email protected]] 
Sent: Wednesday, February 05, 2003 12:45 PM
To: Oracle
Subject: [oracle] RE: reading an external file

Visit www.asktom.oracle and make a search on external tables.
One of those search is here:
http://asktom.oracle.com/pls/ask/f?p=4950:8:2025355::NO::F4950_P8_DISPLAYID,
F4950_P8_CRITERIA:6790030213850,%7Bexternal%7D%20and%20%7Btables%7D

-----Original Message-----
From: Greg Hill [mailto:[email protected]]
Sent: Wednesday, February 05, 2003 12:31 PM
To: Oracle
Subject: [oracle] reading an external file


Hi!

I am working on an EDI situation, and I need PL/Sql to read data from a 
file (.txt for example) which is external to the Oracle databases. The 
Pl/Sql would then INSERT into the tables. I can't figure out how to get 
this to work, I keep getting a 'table not found' error. Any ideas?

Thanks,
Greg
[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.unsub%%.



---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].