Query in SQL Connect to Oracle does not return results
A query in a SQL Connect to an Oracle database is not returning results. The script works in an Oracle SQL Developer tool.
No errors returned.
Steps to Reproduce
Run a query against an Oracle database.
The root cause of this problem is a defect/misconfiguration in the PRPC operating environment.
This issue is resolved by taking the following action to the PRPC operating environment: Restart the application server for the full metadata of the database to be properly read.
Published January 31, 2016 - Updated October 8, 2020
Was this useful?
0% found this useful
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.