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

[Nagendra Batchu]

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]

You can use utl_file package for file operations.

Regards,

Fatih.

[Nagendra Batchu]

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]

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.