Passing datatable type input parameter to stored procedure from java program using JDBC

Question

Hi,

I have a special requirement where I need to stored (update) csv data (Columns in CSV refer to Columns in database table and rows in csv respective to rows in table). I have to write a stored procedure which can accept datatype like datatable in .net. But Since I am working in Java, I dont have anything like datatable datatype. I have Array and Object datatype in Java. But I am not sure how to make use of these datatype in Java application and use them in stored procedure. Could someone please give some documentation on how to send csv data to stored procedure in java program.

This would be very helpful. I have looked all over the internet but didnt get the right answer.

Thanks in advance for the help!

Sujata

Answer 1

http://www.coderanch.com/t/80272/Oracle-OAS/Java-Stored-Procedure-create-csv

http://eshtech.blogspot.com/2012/07/stored-procedure-for-reading-data-from.html