SQL & PL/SQL

I have one .csv file in my local directory ( ex. C:\abc.csv )

I want save this abc.csv as CLOB in one of the CLOB column of the Database Table.

Now I'm doing this in JAVA,but I'm reading the file line by line and writing into the CLOB.

But, for the better performance its not good..

So. Is there any posibility for saving the "abc.csv" file directly into the CLOB column using PL/SQL Procedure ( without reading the file line by line ).


same thing , I have to do in vice versa also. ( i.e. direct conversion CLOB to .csv file with out reading the CLOB line by line)

Please let me know if u have any idea..

Thanks in Advance...

This is my first POST in OTN.

Edited by: Bhaskar on Feb 29, 2012 3:55 AM

Edited by: Bhaskar on Feb 29, 2012 5:29 AM