By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,017 Members | 951 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,017 IT Pros & Developers. It's quick & easy.

Error Calling SPROC that returns multiple result sets

P: n/a
We have a stored procedure (on DB2 8.1 FP5) that returns multiple
result sets which we are calling from Java (WebSphere 5.0.2.8).

We can call the stored procedure from the DB2 command line
successfully.

When we call it from WebSphere, we get the following error:

Execution failed due to a distribution protocol error that caused
deallocation of the conversation. A DRDA Data Stream Syntax Error was
detected. Reason: 0xc.

We also see in the log SQLSTATE 58009 and error code -4,499.

We are using the DB2 Universal JDBC driver. Regular SQL access works
fine (non-sproc statements).

Has anyone come across this error before or have any ideas on what
might be causing it?

Any help is greatly appreciated,
Randy
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.