| || |
SQL in Oracle 10g(Getting missing parenthesis)
Hi, I have a function that executes queries once they are in an array(14. All but one works, gives me an oracle error - missing right parenthesis. Tested query in pl/sql dev and it works.Qtp not complaning about syntax.
I have added a space at the end of each row and removed them, put static/dynamic variables in, live data, but no luck.
Please can someone assist
Below is the query:
"select e.discount_name , b.reason_name, BDisc.* " &_
"from custprodinvbonuslog BDisc , bonusreason b , eventdiscount e " &_
"where e.catalogue_change_id = gnvgen.liveBillingCatalogueID('ZAR') " &_
"and BDisc.customer_ref between " & custRefListLow & " and " & custRefListHigh & " " &_
"and BDisc.bonus_reason_id = b.bonus_reason_id " &_
"and BDisc.event_discount_id = e.event_discount_id " &_
"order by BDisc.award_dtm, BDisc.product_seq , BDisc.bonus_seq desc "