Skip to Main Content
Forums

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!

Call a procedure/function with an array as argument

199845Jun 19 2008 — edited Jan 20 2015
Hello, I need to create a function in PL/SQL which takes one parameter which is a list/array of variable size. Then I must be able to call this function from Java via JDBC. How should the parameter be declared in PL/SQL and how can I construct a list in Java that can be passed in as the argument?

Thanks in advice!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 25 2008
Added on Jun 19 2008
#database-connectivity-discussions
4 comments
3,203 views