plsql-developer
I'm using PL/SQL Developer v9, brio intelligence 6.6 and on another computer SQL Developer v7. On version 7 everything is ok. My table objects are 'expanding' shows all avaiable databases.
In version 9 object does not develop – as if it were empty. When I use BRIO all databases are avaiable…
So there is some problem with PL/SQL Developer but I can't figure it out ;\
It seems your question contains the answer.
By default PL/SQL Developer gathers statistical data per session for every query.
In the SQL Window and in the debugger's Test Window you can use the Statistics page to view the resources used by the last executed SQL statement or program unit. This information can be a big help when optimizing your SQL or PL/SQL code.
If the user you have logged in, dose not heve the privilege to query on v$ views (as described in the error description) you will not be able to see the statistics result in Test Window and the message will be shown.
To solve the problem you may choose any of the approaches bellow:
Grant the user the privilege to select on desired v$ views.
GRANT SELECT ON sys.V_$SESSION TO scott;
GRANT SELECT ON sys.V_$SESSTAT TO scott;
GRANT SELECT ON sys.V_$STATNAME TO scott;
Or disable automatic statistics in PL/SQL Developer in preferences menu.
When you process a script in SQL Developer using the "Run Script" button (not the "Run Statement" button), it uses SQL*Plus internally to execute your script. Therefore using a SQL*Plus control setting which stops processing on errors should work. Try adding to the top of your script line like this:
WHENEVER SQLERROR EXIT FAILURE
Best Answer
I fixed it. A little ridiculous but it was enough to change the 'current user' to 'all users' tab objects