RE: reading an external file
"David, Romeo B. (Govt)" <[email protected]> Wed, 5 Feb 2003 12:45:12 -0500
| Newsgroups | gmane.comp.db.oracle.devel |
|---|---|
| Message-ID | <LYRIS-1796914-862513-2003.02.05-17.45.38--gcdod-oracle#[email protected]> |
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 protected].