467,199 Members | 970 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,199 developers. It's quick & easy.

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
  • viewed: 2330
Share:

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@gmail.com | last post: by
4 posts views Thread by ron | last post: by
reply views Thread by ruju00@gmail.com | last post: by
9 posts views Thread by Ratfish | last post: by
15 posts views Thread by Lawrence Krubner | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.