Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

insert array list from java code into database using procedures

856967Aug 29 2011 — edited Aug 29 2011
Hi,

here's what I have done : I have obtained a l"List" from an external application using Java.
I wrote up some DAO layers and CallableStatements and prepared statement to execute the backend query.


what I have to do : I wrote a backend query attempting to alter a table and create a new row and insert this "List" into the table.

I am getting error because of improper query to insert this List.


As solution, could someone please give me example of how to alter a table and create a row and insert the list from DAO layer ?

Regards,
T
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 26 2011
Added on Aug 29 2011
1 comment
465 views