cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Need to share some code when posting a question or reply? Make sure to use the "Insert code sample" menu option. Learn more! X

Issue with running query on Oracle Database

ptc-6292144
3-Visitor

Issue with running query on Oracle Database

Hello,

 

I have an Oracle Database setup as a thing, and when creating a service as a SQL Query I can see all of the tables within the database (so I have a connection) however, when I try to run a query I get the following error message

 

Error executing service

 

Unable to Invoke Service AcquireLBSProduced on BeloitPPT : ORA-00942: table or view does not exist

 

 

 

 Unsure why I get the message because the table does indeed exist as I can see it in the tables list when creating the service. Any help is appreciated!



2 REPLIES 2

I was able to figure it out. I needed to put the parent in the query when selecting the table

Hey, I have the same issue, what parent you put into query?

Top Tags