How to send multiple rows data from JDBC to oracle stored procedure?

Question

I want to save the multiple rows data in DB using oracle stored procedure from JDBC.

Aware of XML data approach.

Can we send the list or map from java to database and insert in data base from stored procedure.

asifsid88 · Accepted Answer · 2013-02-21 10:01:21Z

0

There are something like "table value parameter" which can help you storing your multiple rows in DB

answered Feb 21, 2013 at 10:01

asifsid88

4,71122 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

required how to achieve this in jdbc?

Mallikarjuna Reddy · Accepted Answer · 2016-04-13 13:24:50Z

0

In Java, We can use the STRUCT Class for Oracle Objects.

For more details, check the below link

answered Apr 13, 2016 at 13:24

1,2122 gold badges20 silver badges33 bronze badges