CODEWITHSUNDEEP
sqldatabaseoracle-databaseplsqloracle-apex
Raz Dwa
Raz Dwa

Reputation: 11

ORA-01410 - Invalid ROWID while trying to UPDATE/DELETE in Oracle APEX

I'm currently creating an app in Oracle APEX and for some unknown to me reason while trying perform UPDATE/DELETE action by clicking on 'edit' button in the report I get this error 'ORA-01410 - Invalid ROWID' but only on 3 out of 10 tables. In those 7 everything works as intended. I've also tried performing these operations without using ROWID in report but it ended up not updating at all. Will be grateful for any help.

enter image description here

enter image description here

Upvotes: 0

Views: 5542

Answers (3)

Raz Dwa
Raz Dwa

Reputation: 11

The issue actually was a wrong type of JOIN on tables, which for some reason I did not expect.

Upvotes: 0

Aladdin Kabil
Aladdin Kabil

Reputation: 9

when you select the rowid from table convert it to varchar2 like the following where ROWIDTOCHAR(rowid) = 'AAAUHLAAJAAAAM8AAD' it will not return the ora error

Upvotes: 0

Leo M.
Leo M.

Reputation: 11

We had a simmilar (same?) issue and discovered that ROWID sometimes converts to a char string that has a special char in it like +. That char is seems to be wrongly interpreted in an autoload event of a form and thus this error is raised. We couldn't solve it so we switched to a different primary key for the form.

Upvotes: 1

Related Questions