oracle - Missing expression error in application used to submit SQL but when works fine in SQL Developer -
when wrote code below in oracle sql developer works fine, when pasting code webwise tool use create reports, errors saying missing experession? copy , paste code , works fine...
code :
select o.wh_id, o.bill_to_code, (case when d.pick_area 'gps%' 'gps' else d.pick_area end) pick_area, count(*) ouc t_order o inner join t_pick_detail d on o.order_number = d.order_number o.wh_id = '~wh_id~' group o.wh_id, o.bill_to_code, (case when d.pick_area 'gps%' 'gps' else d.pick_area end) order o.bill_to_code;
to finalize post, remove ';' ensure works.
as added note. underlying mechanism runs sql may have different interpreter , in cases, cause issues. when dealing various tools interact same platform, ensure syntax correct per documentation of system.
Comments
Post a Comment