ora-1445 in an interactive report
637795Jul 31 2008 — edited Aug 18 2008I'm running into an issue adding an outer join to a SQL statement in an interactive report. When I add (+) to the where clause the I get the following error.
1 error has occurred
* The report query needs a unique key to identify each row. The supplied key cannot be used for this query. Please edit the report attributes to define a unique key column. ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table
When I run the sql in the SQL workshop and it works fine and returns the results I expect. As soon as I add the (+) to the report, it fails. I have duplicated this issue on the apex.oracle.com site and can provide the details on how to reproduce the error.
Thanks,
Bruce