Hi All,
I have installed the latest SQL developer (recently my system got formatted --> Previously I was able to access the views without any issues), observed when I am running views a few of the views are returning results and few of them or not ( I am running the queries as APPS user).
19.1.0 (sqldeveloper-19.2.1.247.2212-x64)
19.2.1 (sqldeveloper-19.2.1.247.2212-no-jre)
Ex: SELECT * FROM APPS.ORG_ORGANIZATION_DEFINITIONS; --> 0 rows returned.
SELECT * FROM APPS.oe_order_headers_all_dfv; --> rows returned
I have tried all the ways that were mentioned in the below notes none of them worked for me. Can you please help me?
https://stackoverflow.com/questions/30298848/sql-developer-not-fetching-rows-for-views
https://stackoverflow.com/questions/5749318/oracle-sql-developer-tables-cannot-be-seen
Also set below things :
AddVMOption -Doracle.net.disableOob=true in --> sqldeveloper\bin\sqldeveloper.conf
Set Java Home : C:\Program Files\Java\jdk1.8.0_251 --> C:\Users\<username>\AppData\Roaming\sqldeveloper\19.2.1\product.conf
Thanks,
Pushpa G