I’m connecting and working with HSQLDB with uipath everything works fine connection made and can call function and tables from uipath but Currently im facing issue while calling procedure from uipath but the same procedure can be called manually from the HSQL DB. “Pr_test” is my procedure name and im passing current date in the parameter. The procedure executed fine when callled from the HSQLDB server but i dont know what the issue here is
The error message is "Execute Query: ERROR  ERROR: unexpected token: PR_TEST;
Error while executing the query
I dont know what this error is please help.
call pr_test(DATE’2021-07-16’); This is how i call from HSQL server it worked fine
Thanks in advance