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!

Oracle APEX Form based on synonym?

946915Jul 2 2012 — edited Jul 2 2012

Hello
I would like to create a page that will have a form on which the users will be able to modify data.
When this form is based on a table in the underlying schema works fine.
However when this form is based on a synonym that points to a table in another schema, every time I try to modify data I get the following error message:

ORA-01410: invalid ROWID

•is_internal_error: false
•ora_sqlcode: -1410
•ora_sqlerrm: ORA-01410: invalid ROWID
•component.type: APEX_APPLICATION_PAGE_PROCESS
•component.id: 3265510108650544
•component.name: Fetch Row from BASE_TABLE_NAME
•error_backtrace:
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1926
ORA-06512: at "SYS.WWV_DBMS_SQL", line 966
ORA-06512: at "SYS.WWV_DBMS_SQL", line 992
ORA-06512: at "APEX_040100.WWV_FLOW_DYNAMIC_EXEC", line 649
ORA-06512: at "APEX_040100.WWV_FLOW_DML", line 334
ORA-06512: at "APEX_040100.WWV_FLOW_PROCESS", line 323

Any ideas?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 30 2012

Added on Jul 2 2012

#apex, #apex-discussions

1 comment

742 views