RE: reading an external file

use utl_file... as in..
	FILE_HANDLE := UTL_FILE.FOPEN('/main/subdir', 'filename.TXT',
'r',200);
	UTL_FILE.GET_LINE(FILE_HANDLE, IN_REC);

this is easier if the file is on the server where the database resides.
and the script also runs on the server

if you are in sqlplus, you can get to all your tables.


-----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%%.

Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.




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