<div>
objects:<br />
<br />
I forgot to mention, I'm running on Oracle 9i. &nbsp;Is there something that will work on 9i? &nbsp;The solution you gave looks like it only works on 10g.
</div>


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.

<div>
believe it should work on any version<br />

</div>


<div>
<div class="content wysiwyg-content">
Can Java execute an Oracle Stored Proc using Named Parameters?<br />
<br />
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. &nbsp;I cannot figure out how to do this. &nbsp;It seems that positional parameters is the only thing that will work in Java.<br />
<br />
Is there a solution for this problem?
</div>
</div>


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?

Can Java execute an Oracle Stored Proc using Named Parameters?

Java is a platform-independent, object-oriented programming language and run-time environment, designed to have as few implementation dependencies as possible such that developers can write one set of code across all platforms using libraries. Most devices will not run Java natively, and require a run-time component to be installed in order to execute a Java program.

Java

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.