aspose file tools*
The moose likes JDBC and the fly likes Result Set from a DB2 stored procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Result Set from a DB2 stored procedure" Watch "Result Set from a DB2 stored procedure" New topic
Author

Result Set from a DB2 stored procedure

Richard Olmstead
Greenhorn

Joined: Jun 12, 2006
Posts: 5
Hello colleagues,
My Java call to a DB2 stored procedure isn't working... the error is
String Literals not supported in procedure calls to DB2/390

and, the code is
String inp = "76021592220080101" ;
String sql = "{call ? := G714.GDDPOHP2(?)} " ;

CallableStatement callable = conn.prepareCall( sql );
callable.registerOutParameter(1, java.sql.Types.CHAR);
callable.setString(2, inp);

I'd be grateful for any advice.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Result Set from a DB2 stored procedure