Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
exception handling cursors
- Thread starter Christi
- Start date
Although we need more information, like what is the content of your cursor/procedure, I would hazard a guess that a VARCHAR2 variable is not large enough.
Are there any points in your code where you are doing a loop (cursor or otherwise) and you are concatenating the contents of a string to itself? Or do you have a variable defined which is of insufficient size for some of the data in your cursor loop?
Are there any points in your code where you are doing a loop (cursor or otherwise) and you are concatenating the contents of a string to itself? Or do you have a variable defined which is of insufficient size for some of the data in your cursor loop?
- Thread starter
- #3
Hi lewisp!
Yea, the first thing I did was check the size of the data versus the size of the variable I declare. that is not problem.
I am also nt concatenating any string.
What I think might be the problem is that I am not looping the cursor.
Any time I try t loop, it will hang.
I don't know.
I may have to rewrite the cursor.
Yea, the first thing I did was check the size of the data versus the size of the variable I declare. that is not problem.
I am also nt concatenating any string.
What I think might be the problem is that I am not looping the cursor.
Any time I try t loop, it will hang.
I don't know.
I may have to rewrite the cursor.
- Status
Similar threads
- Locked
- Question