aspose file tools*
The moose likes JDBC and the fly likes ResultSetMetaData failed with oracle procedure call, JDBC geeks please rescue!!!!!!! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "ResultSetMetaData failed with oracle procedure call, JDBC geeks please rescue!!!!!!!" Watch "ResultSetMetaData failed with oracle procedure call, JDBC geeks please rescue!!!!!!!" New topic
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: ResultSetMetaData failed with oracle procedure call, JDBC geeks please rescue!!!!!!!