ORA-01719

[Giannantonio]

I'm using

PL/SQL Developer Version 13.0.0.1883 (64 bit)
OCI: version 12.1 (12.1.0.2.0)
Oracle Database 12c Standard Edition Release 12.1.0.2.0

In the database, the "compatible" initialization parameter has the value "12.1.0.2.0".

Every time I run "View", "Describe", "Query data", etc. on a table from the Object Browser menu, I get the error
"ORA-01719: outer join operator (+) not allowed in operand of OR or IN".

I activated debugging in the preferences menu and the problem is with this query executed by the program:

00:00:58.799 TOracleQuery $07D7BB60 Start Query.Execute
SQL = select with.*, com.Comments
from sys.all_tab_cols col,
sys.all_col_comments com
where col.owner = 'DEVELOPER'
and col.table_name = 'TEST'
and com.Owner (+) = 'DEVELOPER'
and com.Table_Name (+) = 'TEST'
and com.Column_Name (+) = col.Column_Name
and com.origin_con_id (+) in (1, sys_context('userenv', 'with_id'))
order by col.column_id
:TABLE_NAME = TEST
: OWNER = DEVELOPER

Can you take a look at this problem?

Regards,
Giannantonio

 

[Marco Kalter]

Maybe you are running into Oracle bug 6610822. It is fixed in your 12.1 database version, but maybe the fix is not enabled. To verify, can you connect as SYS and execute the following statement?

alter system set "_fix_control"='6610822:ON'

This enables the fix for Oracle bug 6610822. Restart PL/SQL Developer and try the view/describe option again.