varable value is coming from the next record (which is wrong) of the
specified table in btitle command in sqlplus 2.3.3 in oracle 7.3

---

Request for Question Clarification by brad-ga on 04 Aug 2002 08:25 PDT

hello,

Can you show me that part of your code that includes
"BTITLE"...PERHAPS A FEW LINES ABOVE AND BELOW IT?

brad-ga

---

Clarification of Question by patu111-ga on 04 Aug 2002 09:19 PDT

IN THE PL-SQL 2.3.3 SCRIPT (AS ABC.SQL) :

ABC.SQL IS AS:
COLUMN ADD2 NOPRINT NEW_VAL ADD2B
BREAK ON SUPL SKIP PAGE ON NODUPLICATES
TTITLE COL 05 'HEADING' SKIP 2
BTITLE COL 05 ADD2B SKIP PAGE
COL SUPL HEADING 'SUPL' FORMAT A05
COL NAME HEADING 'NAME' FORMAT A30
SPOOL SUPL.TXT
SELECT SUPL,NAME,ADD2 
       FROM SUPL
       ORDER BY SUPL ;
SPOOL OFF ;
EXIT ;
=========================================================
TABLE DATA:(SUPPOSE THERE ARE TWO SUPPLIERS : SUPL=A001,A002,
                                              NAME=XYZ,PQR
                                              ADD2=INDIA,NEPAL)

RESULT: THERE SHOULD BE TWO PAGES OF RESULT. EACH PAGE FOR EACH SUPPLIER.
IN THE FOOT NOTE/ LAST LINE OF THE FIRST PAGE 'NEPAL' IS PRINTED INSTEAD OF
'INDIA' . SO WHAT IS THE SOLUTION ???