'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.
Solution 1:[1]
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.
Solution 2:[2]
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
Solution 3:[3]
The issue actually was a wrong type of JOIN on tables, which for some reason I did not expect.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | buddemat |
| Solution 2 | Aladdin Kabil |
| Solution 3 | Raz Dwa |