File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes CallableStatement registerOutParameter for CLOB Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "CallableStatement registerOutParameter for CLOB" Watch "CallableStatement registerOutParameter for CLOB" New topic

CallableStatement registerOutParameter for CLOB

Karthikeyan Rajendraprasad
Ranch Hand

Joined: Apr 16, 2003
Posts: 70
hi i am using oracle thin driver to connect to the 9i database. i have a procedure that returns a CLOB. when i tried to set the registerOutParameter as oracle.jdbc.driver.OracleTypes.CLOB or java.sql.Types.CLOB i get an error saying PLS-00306: wrong number or types of arguments in call

can anybody help me out

Karthikeyan<br />SCJP 1.4, SCWCD.
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 32811

Can you post the signature of your stored proc and the code to set the parameters?

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link:
subject: CallableStatement registerOutParameter for CLOB
It's not a secret anymore!