Re-read your question and have a different version to try. Last solution
would run report once for every order number. This one assumes that order

numbers are already in order in the input file "a.txt", and will use the
first for ORD_LOW and the last for ORD_HIGH.



# FCP_USERNAME=`echo $* | awk ' { print $5 } ' | cut -d\" -f2`
FCP_USERNAME=NJ_SCHEDULE FCP_LOGIN=APPS/xxxxx
ORDER_LIST=a.txt
F_COUNT=0

export PATH
ORACLE_HOME=/d1app03/oracle/testora/8.0.6
TNS_ADMIN=/d1app03/oracle/testora/8.0.6/network/admin/test_uxprd
export TNS_ADMIN
ORACLE_SID=test

while read -r order_number
do
F_COUNT=`expr $F_COUNT + 1`
if [ $F_COUNT -eq 1 ]
then
ORD_LOW=$order_number
fi
done < $ORDER_LIST

ORD_HIGH=$order_number

CONCSUB ${FCP_LOGIN} "OE" "Order Entry USA Expedite" ${FCP_USERNAME}
WAIT=Y CON CURRENT ARO AROOEACK PRINTER=isdl NUMBER_OF_COPIES=1
PRINT_STYLE=LANDSCAPE {'1'
,'191','MSTK','D','ORDER','""',${ORD_LOW},${ORD_HIGH},'""','""','""','""
','""','
""','""','""','""','""','N'}


**********************************************************************
This e-mail message is intended only for the personal use of the
recipient(s) named above. This message is confidential. If you are not an
intended recipient, you may not review, copy or distribute this message.
If you have received this communication in error, please notify the sender
immediately by e-mail and delete the original message.
**********************************************************************

Oracle LazyDBA home page