开发者

How to close a DB2 cursor from OLEDB client?

I have client utility that uses OLEDB to call a DB2 stored procedure. Inside the stored a procedure a cursor is opened so my utility can read record sets. Everything works fine but after a while of calling the same procedure over and over again, DB2 eventually throws an error that is related to the cursor being left open. Is there a sql command in DB开发者_JAVA百科2 to close the last used cursor or something similar?


I can't see how to do it from the client, but in the sp the code should be calling Close CursorName;. Can you not update the procedure?

See here for an example.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜