Java Database Connectivity (JDBC)

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 multiple records into Oracle using Java

51564Dec 1 2006 — edited Dec 5 2006

Hi,

Has anyone tried to insert multiple records into an Oracle table from Java? I have my data in a Java collection.Can I send a Java Collection to an Oracle Package as a PL/SQL Table Type? My problem is I dont want to instantiate a CallableStatement object everytime I do an insert. Instead I want to do that only once and then insert multiple records in one operation.

Any suggestions will be appreciated,

Thanks,
Alex

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 2 2007

Added on Dec 1 2006

#java-database-connectivity-jdbc

5 comments

1,959 views