Is not possible open list View and Table in Developer

[LuPe]

We have version 7.1.4.1388 PL/SQL Developer and Oracle 11.
One user from five not open list View and list Table.
Developer report ORA00920:invalid relation operator.

How make repair?

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the shortcut and add the DebugSQL parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" DebugSQL

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory or in the %APPDATA%\PLSQL Developer directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer).

 

[LuPe]

On my computer work all OK. I have debug.txt file.
I am in admin group in network.

On users computer not generated debug file.
When I change right from users to administrator (on computer), is all the same.
Any Tables, any Views to display, but all Tables and all Views to work and select formulas.

 

[LuPe]

My debug.txt

PL/SQL Developer
Version 7.1.4.1388
Windows XP Professional 5.1 Build 2600 (Service Pack 3)

Physical memory : 2

 

[Marco Kalter]

Can you send me the complete debug.txt file?

 

[LuPe]

Physical memory : 2

 

[LuPe]

Now is it OK?
I send it using webservice leteckaposta.cz

 

[Marco Kalter]

We have received it. There is no "ORA-00920: invalid relation operator" in the log file though. Did this error occur during the session you logged? Can you retry and check for ORA-00920?

 

[LuPe]

There was my debug.txt
At users computer this file wasn't created.
I think, but problem is in users right for network and servers. Is this possible?

The ORA error is with opening list Views or Tables. User with this Views and Tables can work, make select and next operation.
But not open list.

 

[Marco Kalter]

Can you send me a debug.txt file with the ORA-00920? I would like to see the statement that lead to this error.

 

[LuPe]

My configuration
PL/SQL Developer
Version 7.1.4.1388
04.46063 - 5 user license
Windows XP Professional 5.1 Build 2600 (Service Pack 3)

User configuration
PL/SQL Developer
Version 6.0.4.906 (MBCS)
01.24959 - 1 user license
Windows XP version 6,0 (build 2600) Service Pack 3

Is possible, but parameter for debug DebugSQL is for version 6 different?
On users computer was not created debug.txt

 

[Marco Kalter]

Version 6.0 does indeed not know the DebugSQL parameter. You can use the Debug parameter instead.

 

[LuPe]

ORA-00920: invalid relational operator
At line 6, position 1
select object_name, owner object_owner, status, object_type, created, last_ddl_time
from sys.all_objects o
where object_type = bject_type
:extra_condition
and (B

 

[LuPe]

and (Burger)
order by decode(owner, user, 0, 1),
owner,
object_name

I dont know, why is here this condition.
Where is the place for delete this condition?

 

[Marco Kalter]

Go to Tools > Browser Filters and modify the where clause and/or order by clause of the filters.

 

[LuPe]

All is OK now. Thank you