aspose file tools*
The moose likes Oracle/OAS and the fly likes How to read a text file from the system and load the data in to a table in oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "How to read a text file from the system and load the data in to a table in oracle" Watch "How to read a text file from the system and load the data in to a table in oracle" New topic
Author

How to read a text file from the system and load the data in to a table in oracle

Nagendra Batchu
Ranch Hand

Joined: Jan 23, 2008
Posts: 32
hi Friends,

I have to write a stored procedure to read a text file from c:/fileData directory and insert each row as a record in the oracle table.

Please help me in solving this problem.

Thanks in Advance
Fatih Keles
Ranch Hand

Joined: Sep 01, 2005
Posts: 182
You can use utl_file package for file operations.

Regards,

Fatih.
Nagendra Batchu
Ranch Hand

Joined: Jan 23, 2008
Posts: 32
Thanks for your reply,

To my knowledge we can read the file using UTL_FILE package from the server, But my requirement is to read the file from local system.


Please suggest some sample code for Reading the file .


Thanks in Advance
Fatih Keles
Ranch Hand

Joined: Sep 01, 2005
Posts: 182
You can not read a file with pl/sql procedure which is on clients' local file system. You have to upload it to server.

Regards,

Fatih.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to read a text file from the system and load the data in to a table in oracle