How Pass the multiple parameters in Execute Query

[nagavelly.naveen]

Hi all,

My Query is
SELECT PH_TXN_CODE PO_TXN_CODE,PH_COMP_CODE PO_COMP_CODE, GH_TXN_CODE GRN_Txn_Code,GH_NO GRN_Doc_No,GH_DT GRN_Doc_Dt,GH_SUPP_CODE Supplier_Code,SUPP_NAME Supplier_Name,GH_SUPP_DEL_REF DO_Ref_No,GH_SUPP_INV_REF Inv_Ref_No
FROM OT_GR_HEAD,OT_GR_REF,OM_SUPPLIER,OT_PO_HEAD
WHERE GR_GH_SYS_ID = GH_SYS_ID AND GH_SUPP_CODE = SUPP_CODE AND PH_SYS_ID = GH_REF_SYS_ID
AND GH_SUPP_CODE = ‘S001762’ AND GR_REF_NO = :PO_NO AND NVL(GH_SUPP_DEL_REF,GH_SUPP_INV_REF) = :DO_NO
AND EXISTS (SELECT 1 FROM OT_GR_ITEM WHERE GI_GH_SYS_ID = GH_SYS_ID

Passing Parameters as

But it returns empty values
If i’ try with manually entered values in Query it extracted the values

Please help me…

[Parth_Doshi]

check this video if it helps you: Getting Complete/Partial SQL Database and Converting Into Data Table Using UiPath - YouTube

[nagavelly.naveen]

I need answer Dude…
in that PO_NO is not working

[Parth_Doshi]

try keeping the variable name same as the column name in the database.

[nagavelly.naveen]

I don’t know about Queries
The Query is shared by Database expert. so i must need to use this query only

please provide solution for this query

[poorna_nayak07 (Poornachandra M)]

Have you found the solution…? @nagavelly.naveen