Convert CSV data held in a CLOB into columns

Oracle 10gR2

Would like to be able to support upload of a CSV file and then populate a "staging" table with its contents.

• use first line of file as column names
• load lines 2 to end of file as rows into a table, populating only those columns identified in the header row

The thought was we could load the file into a BLOB (I should mention we're using OHS / mod_plsql so this is standard file upload)), convert it to CLOB and then (somehow) parse the content.

Antbody any pointers to examples where this has been done before?

Other suggestions? Have thought about external tables - perhaps that is a better approach?

-- 
jeremy