File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
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
Did you see how Paul
cut 87% off of his electric heat bill with 82 watts of micro heaters
subject: function sequence error in DB2
Little hitch trying to use the JDBC tool
How to close ResultSet in a function after returning it
How to execute an scalar query ?
hibernate: could not get next sequence value
DB issue (prepared statement)
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013