| Author |
ResultSetMetaData failed with oracle procedure call, JDBC geeks please rescue!!!!!!!
|
Wei He
Greenhorn
Joined: Jul 31, 2002
Posts: 1
|
|
|
When I do a query (like a select statment) in my JDBC program, I can get the resultSetMetaData back and use any methods under it. But when I make a procedure call in my program, calling any method under ResultSetMetaData causes a "NullPointerException". I know my procedure call is right, because I can retrieve the return values with callableStatement.get??? method. Does anyone know why resultSetMetaData does not work with procedure calls? I'm using JDBC 2 and Oracle817.
|
 |
Premkumar N
Greenhorn
Joined: Apr 21, 2001
Posts: 22
|
|
I guess u need to provide more details ..
IS your procedure returns a scalar return value or a string?
Then result-set does not have any meaning.
IF it returns a CURSOR then resultset would return the appropriate TYPE of the CURSOR and the COLUMN_NAMES etc etc..
HTH
Thanks,
Prem
|
<a href="mailto:pondyprem@yahoo.com" rel="nofollow">pondyprem@yahoo.com</a> <br />Sr.Programmer Analyst ( Bioinformatics)<br />Monsanto Entrprises
|
|
 |
|
|
subject: ResultSetMetaData failed with oracle procedure call, JDBC geeks please rescue!!!!!!!
|
|
|
0
