Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Cursor and SQLCODE=100

Cursor and SQLCODE=100

From: <dkefford_at_fair1.fairfield.edu>
Date: 1998/02/03
Message-ID: <886514672.1407844354@dejanews.com>#1/1

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 Usenet
Received on Tue Feb 03 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US