Hi ALl,
How to call a oracle Procedure from uipath.
I tried Execute Query/Execute Non Query options with command type as store procedure
“xx_test()”
“execute xx_test();”
“Begin xx_test(); end”
“Begin xx_test(); end;”
I am receiving different errors
RemoteException wrapping Oracle.ManagedDataAccess.Client.OracleException: ORA-06550: line 1, column 15:
PLS-00103: Encountered the symbol “XX_TEST” when expecting one of the following:
:= . ( @ % ; immediate
The symbol “:=” was substituted for “XX_TEST” to continue.
ORA-06550: line 1, column 26:
PLS-00103: Encountered the symbol “)” when expecting one of the following:
Execute Non Query: ORA-06550: line 2, column 1:\nPLS-00201: identifier ‘XX_TEST’ must be declared\nORA-06550: line 2, column 1:\nPL/SQL: Statement ignored"