Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 401
  • Last Modified:

Can Java execute an Oracle Stored Proc using Named Parameters?

Can Java execute an Oracle Stored Proc using Named Parameters?

I have a situation where I need to execute a stored procedure in Oracle from Java, and the only way this procedure can be called is by naming the parameters individually.  I cannot figure out how to do this.  It seems that positional parameters is the only thing that will work in Java.

Is there a solution for this problem?
0
jbaird123
Asked:
jbaird123
  • 2
  • 2
1 Solution
 
jbaird123Author Commented:
objects:

I forgot to mention, I'm running on Oracle 9i.  Is there something that will work on 9i?  The solution you gave looks like it only works on 10g.
0
 
objectsCommented:
believe it should work on any version
0
 
jbaird123Author Commented:
Thank you!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now