Re: Running SQLPlus from command line

On Oct 12, 9:44 am, "RLN" <rlntemp-newsgr..._at_yahoo.com> wrote:
> ok....trudging along here....
>
> After the batch file runs, Test12.txt contains no data and is zero
> bytes in size.
> What else am I missing in this process?
> Here are my updated files:
>
> - - - - - - -
> <begin TEST12.BAT>
> rem Connect to SQL...
> SQLPLUS -s myLogon/myPass_at_myDBName @TEST12.SQL
> Echo done running TEST12.BAT
> <end TEST12.BAT>
> - - - - - - -
>
> <begin TEST12.SQL>
> --Spool output to text file
> SPOOL test12.txt
>
> SELECT DISTINCT A.PROCESS_INSTANCE,
> A.BUSINESS_UNIT,
> A.VOUCHER_ID,
> A.VOUCHER_LINE_NUM,
> A.BUSINESS_UNIT_PO,
> A.PO_ID, A.LINE_NBR,
> A.SCHED_NBR,
> A.BUSINESS_UNIT_RECV,
> A.RECEIVER_ID,
> A.RECV_LN_NBR,
> A.RECV_SHIP_SEQ_NBR,
> A.MATCH_RULE_ID,
> A.SETID,
> A.MATCH_CNTRL_ID,
> A.BUYER_ID,
> B.MERCHANDISE_AMT,
> B.QTY_VCHR,
> C.IMAGE_REF_ID
> FROM PS_VCHR_MTCH_EXCPT A,
> PS_VOUCHER_LINE B,
> PS_VOUCHER C
> WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT
> AND A.VOUCHER_ID = B.VOUCHER_ID
> AND A.VOUCHER_LINE_NUM = B.VOUCHER_LINE_NUM
> AND B.BUSINESS_UNIT = C.BUSINESS_UNIT
> AND B.VOUCHER_ID = C.VOUCHER_ID
> And A.PO_ID in('0000877894')

Syntax error: no terminating semicolon ;
>
> --turn off spooling...
> SPOOL OFF
>
> -- Exit SQLPlus...
> EXIT
> <end TEST12.SQL>
>
> Thanks.
Received on Fri Oct 13 2006 - 07:12:04 CDT