CSV to Oracle DB - Upload File

[Former Member]

Dear All,

I have a scenario where I need to upload data in csv format to tables in Oracle DB. Here is the detailed description of problem.

a) User selects a csv file on his desktop which has data in it in csv format.

b) A BLOB is inserted in Oracle DB table "FileData_Tab" once user clicks on upload button.

c) A row insert trigger will be invoked on inserting the data which invokes a <b>stored procedure to reconstruct the csv file, read the data from it, and update the data accordingly to respective tables fields</b>.

My only concern is in step 'c'. Is it possible in Oracle to have a stored procedure which re-constructs a csv file, and updates the tables.

Thanks in advance.

Regards,

Chaitanya

[Former Member · Accepted solution]

Here you have an article I used to get csv from an oracle cursor with pl/sql functions. There is another to insert from a csv. They are very simple. Maybe it could be help for you with a little modification.

http://articles.techrepublic.com.com/5100-9592_11-5259821.html

Best regards. Be generous.

Aníbal Pozo.