java – passing array in oracle stored procedure

by

the type VARCHAR2_ARR is a PLSQL type, you won’t be able to interface it directly from java. I suggest you look into this thread on AskTom regarding a similar question.

Here are a couple suggestions:

  • create a SQL TYPE that you can bind from java
  • insert into a temporary table from java and read from it in plsql

In both cases you will have to either modify the PLSQL procedure or add a new translation procedure.

More Related Contents:

  1. How to call oracle stored procedure which include user-defined type in java?
  2. pass array to oracle procedure
  3. JAVA ArrayIndexoutofBoundException issue
  4. Write a program that takes an array/arraylist of integer and finds longest sub array/arraylist whose entries are equal [closed]
  5. How to add two int array values together?
  6. Difference between int[] array and int array[]
  7. How to split a String by space
  8. The best way to print a Java 2D array? [closed]
  9. How do I copy a 2 Dimensional array in Java?
  10. What is the Cost of Calling array.length
  11. How to convert object array to string array in Java
  12. How to return an array from JNI to Java?
  13. How to convert a Java 8 Stream to an Array?
  14. How do I fill arrays in Java?
  15. Hibernate could not fetch the SequenceInformation from the database
  16. MyBatis Batch Insert/Update For Oracle
  17. How to access nested elements of json object using getJSONArray method
  18. how calculate java array memory usage
  19. Why can I edit the contents of a final array in Java?
  20. How to manipulate arrays. Find the average. Beginner Java
  21. How to find the only number in an array that doesn’t occur twice [duplicate]
  22. Time Complexity for Java ArrayList
  23. How to deep copy an irregular 2D array
  24. java: Arrays.sort() with lambda expression
  25. Connection cannot be cast to oracle.jdbc.OracleConnection
  26. Return the index of clicked button?
  27. what is Ljava.lang.String;@
  28. Create an array of ArrayList elements
  29. Iterating a ResultSet using the JDBC for Oracle takes a lot of time about 16s?
  30. java : Understanding Arrays.asList(T…array) method for primitive types

Leave a Comment