ORA-01719 When Executing Outer Join Query With Isnull() On Referenced Object
(Doc ID 825611.1)
Last updated on JUNE 23, 2021
Applies to:Oracle TopLink - Version 126.96.36.199.1 to 188.8.131.52.2 [Release Oracle11g]
Information in this document applies to any platform.
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
(t1.ID (+) = t0.COMPANY_ID and t0.COMPANY_ID IS NULL)
(t1.ID (+) = t0.COMPANY_ID and t1.NAME LIKE 'Demo%')
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