i am new to the UIPath and still learning. I got stuck with what seems to be a simple thing. UIPath test makes connection to oracle db, reads the query from the file, but can’t execute it because it doesn’t recognize the schema (INST) in my query:
Execute Query: ERROR [42S02] [Oracle][ODBC][Ora]ORA-00942: table or view does not exist
If i copy query from the variable in debug mode, and then execute the same query directly in toad (not setting schema beforehand) it runs just fine. I also asked my teammate to run my code on his machine in the same environment - it runs fine. In this forum i found one similar problem where user solved the problem by adding schema to table, so it wasn’t helpful as I am already doing it…
Here’s the query:
select myfile.file_datetime, myfile.user_nm, myfile.file_nm,
from INST.myfile myfile
WHERE (myfile.file_datetime BETWEEN TO_DATE (’__Start_Date’, ‘yyyy/mm/dd hh24:mi:ss’) AND TO_DATE (’__End_Date’, ‘yyyy/mm/dd hh24:mi:ss’))
Any advice is greatly appreciated.