My Oracle Support Banner

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

Last updated on JULY 31, 2024

Applies to:

Oracle TopLink - Version 11.1.1.0.1 to 11.1.1.0.2 [Release Oracle11g]
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References

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