I am unable to execute the SQL query

[rv.jain9277]

“Select Distinct AD.TO_LOC
FROM ALLOC_HEADER AH, ALLOC_DETAIL AD
WHERE AH.ALLOC_NO = AD.ALLOC_NO
And AH.ORDER_NO = @PO”

I am trying to execute the above query as @PO is the Argument with contains the String value.
It gives the error as

Run query: ERROR [HY000] [Oracle][ODBC][Ora]ORA-00936: missing expression

[marian.platonov]

Try to build the query before the Run query activity and save it in a separate file.

Then, read the file content as a string. In the end, in the Run query activity, use the stored string value as the query.

Let us know if this helped you.

[jeevith (Jeevith Hegde, Ph.D.)]

Hi @rv.jain9277,

Let SQL do the hardwork for you. Why not use Stored Procedure? That way you dont have to bother about string syntax’s. You call a Stored Procedure and it returns your query for you.

You still use the same Execute Query, but using a Stored Procedure will make the code easier to read and set a clear separation between UiPath and SQL related logic in your code.

Here is how you use Stored Procedure and parameters

SQL Stored procedure Passing Parameters To fetch particular records

Hi @pari_patel, I am assuming that you have set up your connection correctly using “Connect to DB” activity. The “Execute Query” activity takes the output of “Connect to DB” activity "Connect to DB" ---> "Execute Query" UiPath has a strict syntax requirement for parameters in the “Execute Query” activity (only takes String expressions). If your StoredProcedure takes in one parameter StoredProcedure = YourStoredProcedure Parameter for StoredProcedure = @YourRequiredParameter Variable f…