Solved

Can Java execute an Oracle Stored Proc using Named Parameters?

Posted on 2010-09-21
4
393 Views
Last Modified: 2013-11-23
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
Comment
Question by:jbaird123
  • 2
  • 2
4 Comments
 
LVL 92

Accepted Solution

by:
objects earned 500 total points
ID: 33730316
0
 

Author Comment

by:jbaird123
ID: 33730440
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
 
LVL 92

Expert Comment

by:objects
ID: 33730454
believe it should work on any version
0
 

Author Closing Comment

by:jbaird123
ID: 33754637
Thank you!
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Basic understanding on "OO- Object Orientation" is needed for designing a logical solution to solve a problem. Basic OOAD is a prerequisite for a coder to ensure that they follow the basic design of OO. This would help developers to understand the b…
This tutorial covers a practical example of lazy loading technique and early loading technique in a Singleton Design Pattern.
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now