Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

function sequence error in DB2

 
kishore goswami
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all

I am accessing a stored procedure in DB2 which is returning a resultset.
The first time i access the SP ,Iam able to get the resultset and print its values.

but after that for subsequent runs it is giving
db2exception : function sequence error
Iam closing the resultset,statement and connection after each run.

Any help would be greatly appreciated
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Kishore,
Does this happen for all of your user defined functions or just this one? If you don't have any others, try simplifying this one to do a simple query to test this out.

If it only affects this function, you can post the function to see if anyone has an idea.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic