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


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
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!!!!!!!
 
Similar Threads
How to fetch Table Name
how to call stored procedure and also get parameters from the web page
How to call database stored procedures using EJB ??
Debug an Oracle procedure fired from JDBC?
how to call stored procedure and also get parameters from the web page