Missing expression error in application used to submit SQL but when works fine in SQL Developer

Question

When I wrote the code below in Oracle SQL Developer it works fine, when pasting this code into Webwise a tool we use to create reports, it errors saying missing experession? We usually just copy and paste the code and it works fine...

Code is :

select o.wh_id, 
       o.bill_to_code,
       (case when d.pick_area like 'GPS%' then 'GPS' 
             else d.pick_area
       end) as pick_area,
       count(*) as OUC
  from t_order o 
       INNER JOIN
       t_pick_detail d
         on o.order_number = d.order_number
 where o.wh_id = '~wh_id~'
group by o.wh_id, 
         o.bill_to_code,
         (case when d.pick_area like 'GPS%' then 'GPS' 
               else d.pick_area
         end)
order by o.bill_to_code;

Answer 1

To finalize this post, Remove the ';' to ensure it works.

As an added note. The underlying mechanism that actually runs your SQL may have a different interpreter and in some cases, this will cause issues. When dealing with various tools that interact with the same platform, ensure syntax is correct per the documentation of that system.