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!

Using ROWID as a primary key on a grid throws ORA-01445 when using search plugin

alexhafnerFeb 14 2018

I'm using ROWID on a table with a composite PK as this is a supported workaround in FOEX for the single PK column in composite PK scenarios. When I add a Select List column to the query, and then use the search plugin to search a value, it throws


ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table
ORA-06512: at "FOEX_030100.FX_P_GRID", line 2905

We've rebuilt this issue on the trial instance https://trial.tryfoexnow.com/ords/f?p=268:60104

This post has been answered by FOEX GmbH on Feb 15 2018

Jump to Answer

Added on Feb 14 2018

#foex, #foex-bug

6 comments

780 views