ORA-01719 When Executing Outer Join Query With Isnull() On Referenced Object (Doc ID 825611.1)

Last updated on JULY 31, 2024

Applies to:

Symptoms

An Entity (Person) has ManyToOne relationship to an Entity (Company).
An Outer join query checks referenced object for being NULL :

A correct generated SQL query can be: 

SELECT t0.ID, t0.NAME, t0.COMPANY_ID
FROM PERSON t0, COMPANY t1
WHERE
(t1.ID (+) = t0.COMPANY_ID and t0.COMPANY_ID IS NULL)
or
(t1.ID (+) = t0.COMPANY_ID and t1.NAME LIKE 'Demo%')

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.