Carey Brown wrote:I haven't worked with cursors but the FETCH doc I was reading said that if you end it with "ONLY" that tells the DB to close the cursor after executing that statement. It looks like the next thing you are trying to do is use the cursor, which is probably closed.
Carey Brown wrote:I think he mentioned Derby way back. Would have to double check with the OP. What do you say Bob?
As do I. Different databases have different ways of handling database entity names with upper case in them. You can get into a lot of trouble that way.
Carey Brown wrote:I also prefer the convention of writing SQL with keywords in all-caps and non-keywords in lower case.