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.

score 0 · Answer 1 · answered Feb 21 '13 at 10:01

0

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

answered Feb 21 '13 at 10:01

asifsid88

See this http://stackoverflow.com/questions/10217922/how-to-use-array-table-parameter-to-oracle-odp-net-10g-via-ado-net-c – asifsid88 Feb 21 '13 at 10:01
required how to achieve this in jdbc? – Mallikarjuna Reddy Feb 21 '13 at 10:12

score 0 · Accepted Answer · answered Apr 13 '16 at 13:24

0

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

For more details, check the below link

answered Apr 13 '16 at 13:24

2 Answers2