Import file and update table using pl/sql

[sbhujbal]

Hello,
I am having file with 2 fields contains correct value and wrong value. I want to use this file as input to my pl/sql procedure and update values in my table where wrong value by correct value....
How to read file using pl/sql .........???

Sunil

[mber]

Basically, it depends on files located in client side or server side. If it is located in client side, you can use package TEXT_IO, otherwise use UTL_FILE to resd the file and write files.

Take care