CODEWITHSUNDEEP
oracle-apex
Amol
Amol

Reputation: 428

Error When Named LOV assigned to column in interactive report

When in a Interactive Report managed by rowid, and named LOV is assigned to a column I am facing following error:

ORA-20001: get_dbms_sql_cursor error ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table

If it is managed by Primary Key ,issue gets resolved.Can anybody suggest a reason for this error.

Upvotes: 0

Views: 604

Answers (1)

Typo
Typo

Reputation: 1900

From oracle's forum

You need to set an alias to the rowid column in your query

like: select rowid as column_rowid from emp;

Upvotes: 1

Related Questions