Oracle Proedure

Hi All,

how to execute below procedure with execute non query activity

EXEC odbproc_daily_sales_dan3(XXXX844570,‘826LLC’,‘0’,‘zzzzzzzzzzzzzzzz’,‘0’,‘zzzzzzzzzzzzzzzz’,‘0’,‘zzzzzzzzzzzzzzzz’,‘0’,‘zzzzzzzzzzzzzzzz’,TO_DATE(‘30/09/2020’,‘dd/MM/yyyy’),‘CLXXXXN’)

i tried like attachment

But i’m getting error :Execute Non Query: ERROR [42000] [Oracle][ODBC][Ora]ORA-00900: invalid SQL statement

Please help me asap

I’m stucked please help with this

thankyou in advance

Can you please check the Type in parameters as the 1st parameter in Procedure looks like int and in Uipath given as String.

1 Like