| Author |
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
internet detective
Marshal
Joined: May 26, 2003
Posts: 26496
|
|
Karthikeyan, Can you post the signature of your stored proc and the code to set the parameters?
|
[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
|
 |
 |
|
|
subject: CallableStatement registerOutParameter for CLOB
|
|
|