[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 402
  • 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

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

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