L33_WRX

Using Toad for Oracle Version 9.0.1.8 scripts I've ran in the previous version of toad don't seem to allow the '&TBC' function to work? Example of my script below

Related section:

AND MONTHS_BETWEEN(TO_DATE('&TBC','DD-MM-YYYY')

Whole SQL:

SELECT acc_account_no, acc_subacc_no, acc_act_code, acc_incep_date, intc_code, intc_term_control, term_intc_code, term_intr_subcode, term_interval
FROM accounts, interest_controls ic, term_bands tb1
WHERE acc_process_status = 2
AND acc_soc_seqno = 1
AND acc_intc_code = ic.intc_code
AND ic.intc_code = tb1.term_intc_code
--AND tb1.term_intr_subcode <> 999
AND ((ic.INTC_TERM_CONTROL = 8
AND MONTHS_BETWEEN(TO_DATE('&TBC','DD-MM-YYYY'), acc_incep_date) > tb1.term_interval
AND MONTHS_BETWEEN(TO_DATE('&TBC','DD-MM-YYYY'), acc_incep_date) < tb1.term_interval + 1 )
OR (ic.INTC_TERM_CONTROL = 5
AND MONTHS_BETWEEN(TO_DATE('&TBC','DD-MM-YYYY'), ic.INTC_FIXED_DATE) > tb1.term_interval
AND MONTHS_BETWEEN(TO_DATE('&TBC','DD-MM-YYYY'), ic.INTC_FIXED_DATE) < tb1.term_interval + 1 ))
ORDER BY acc_account_no, acc_subacc_no


ANY IDEAS? IS THERE A NEW '&TBC' FOR THIS VERSION??

Cheers

DJ Dunk

iTrader: (5)

I'm using Toad 9.5.0.31 although I'm no expert. What did this variable result in before?

L33_WRX

pop up box displayed so that a user can input various values each time (in this case a date)

DJ Dunk

iTrader: (5)

Oh, okay I thought it may be a special variable that it was pulling in. Can't help except to say that my version prompts for input when using variables.

J4CKO

iTrader: (1)

I think its one of the options, scan for variables or something.

T4molie

I thought you had to have an "accept" statement at the fron of the sql?