File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Soft Skills: The software developer's life manual this week in the Jobs Discussion forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

ResultSetMetaData failed with oracle procedure call, JDBC geeks please rescue!!!!!!!

 
Wei He
Greenhorn
Posts: 1
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 22
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic