A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Arduino in Action
this week in the
A special promo:
Enter your blog post or vote on a blogger to be featured in an upcoming Journal
function sequence error in DB2
Joined: Aug 13, 2003
Oct 21, 2004 03:11:00
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
Joined: May 26, 2003
Oct 21, 2004 18:26:00
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
If it only affects this function, you can post the function to see if anyone has an idea.
How To Ask Questions The Smart Way
Blogging on Certs:
SCEA Part 1
Part 2 & 3
Core Spring 3
TOGAF part 1
I agree. Here's the link:
subject: function sequence error in DB2
hibernate: could not get next sequence value
How to close ResultSet in a function after returning it
Little hitch trying to use the JDBC tool
DB issue (prepared statement)
How to execute an scalar query ?
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013