Hello experts,
I am trying to execute a query, when I fill dataset from data adapter I got this following error:
ORA-00923: FROM keyword not found where expected
but this query execute successfully in sql.
what will be the possible reason and how to solve it?
my sql query is :
SELECT po.po_no, po.po_item, po.matnr, to_char(to_date(po.crdat_po,'YYYYMMDD'),'DD-MON-YYYY') as "crdat_po", po.plant_des, po.sloc, po.quantity, po.used_quantity, po.quantity - po.used_quantity as "balanced_qty", mt.section, mt.quality, mt.LENGTH,mt.description,case(po.po_type) when 'R' then 'ROAD' when 'W' then 'WAGON' end as "po_type", po.sap_quantity FROM ylpct_purord_dtl_dst po, t_material_master mt WHERE po.matnr = mt.material_no AND po.status = 'A' and po.po_no='0003107653' and po.po_item='00001' and po.ord_type='DO' and po.PLANT_SUP ='027' order by po.PO_NO, po.PO_ITEM