Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Cursor and SQLCODE=100
Greetings all...
I hope I can describe this problem clearly. I need to make a modification to a program that prints a single page per person requesting this information. Currently , the program will embed a newpage character ('^L') in between persons' records so they print on separate pages. However, the last person's page clearly does not need another newpage character. Additionally, requests are often made one at a time, meaning it is possible that 100 requests are processed, with a blank page following each one. This, you can see, is wasteful.
So... how is this relevant to this newsgroup??? I need to know when FETCH generates a SQLCODE = +100. Is this code set _when_ the last record is FETCHed, or _after_ the last record has been FETCHed and when the next FETCH fails? This is important, because if it happens _afterward_, then it is too late to for me to suppress printing the '^L' (at least, with the current logic.)
Do I need to change my program logic?
I would appreciate any hints.
Cheers,
dan kefford
programmer analyst
fairfield university
dkefford_at_fair1_dot_fairfield_dot_edu
-------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ Search, Read, Post to UsenetReceived on Tue Feb 03 1998 - 00:00:00 CST
![]() |
![]() |