471,831 Members | 1,598 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,831 software developers and data experts.

Error Calling SPROC that returns multiple result sets

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
0 2443

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Wayno | last post: by
2 posts views Thread by vishal | last post: by
1 post views Thread by dkode8 | last post: by
4 posts views Thread by ron | last post: by
9 posts views Thread by Ratfish | last post: by
15 posts views Thread by Lawrence Krubner | last post: by
reply views Thread by YellowAndGreen | last post: by
aboka
reply views Thread by aboka | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.