Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ora-1445 in an interactive report

637795Jul 31 2008 — edited Aug 18 2008
I'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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 15 2008
Added on Jul 31 2008
30 comments
2,808 views