Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Nagendra Batchu
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 182
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can use utl_file package for file operations.

Regards,

Fatih.
 
Nagendra Batchu
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 182
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic