It you do decide you want to go the PL/SQL route you want want to visit this URL:

http://www.quest-pipelines.com/Pipel...s/Gen_util.sql

It's a PL/SQL package you can download that parses a line from a CSV file and returns it as a nested table array. I reckon it could make life considerably simpler.

Hope it helps.

Austin