Search code examples
stored-proceduresjdbcjava-stored-procedures

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


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.


Solution

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

    For more details, check the below link

    https://docs.oracle.com/cd/B10501_01/java.920/a96654/oraoot.htm