RE: reading an external file

Thanks for your reply. I tried this, got this error:
PLS-00222: no function with name 'GET_LINE' exists in this scope

I am in Oracle 8i.


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