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!

How to call a PL/SQL Procedure having Null Parameters using JDBC?

843854Mar 12 2002 — edited Mar 12 2002

Hi,

Could anyone please let me know how I could call a PL/SQL procedure or a function from a JDBC
method using CallableStatement? The procedure has 4 IN parameters - Param1,
Param2, Param3, and Param4. Values are available for Param1 and Param2. Param3
and Param4 have NULL values. Param3 has a SQL datatype of NUMBER and Param4 has
a SQL datatype of Varchar2.

We are using JDBC 2.0.

Incidentally, I have gone through the JDBC 2.0 Course at http://developer.java.sun.com and have not been able to get what I wanted.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 9 2002

Added on Mar 12 2002

#java-database-connectivity-jdbc

1 comment

187 views