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!

Ora-01461 ora-02063 performing MRU on remote table

ABD - DBAJan 30 2007 — edited Aug 27 2007

I'm hosting my Apex on an IAS 10g R2 middletier server. I created an application, and then created a Tabular Form on a remote table, it is accessing the remote table using a view and a database link. All looks good until I try to update one of the records and I receive the following error:

Error in mru internal routine: ORA-20001: Error in MRU: row= 1, ORA-01461: can bind a LONG value only for insert into a LONG column ORA-02063: preceding line from TBBUAT, update "TBBPLAY"."REPORT_DAEMON" set "REPORT_ID" = :b1, "REPORT_NAME" = :b2, "SELECT_FORMULA" = :b3, "PRINT_NAME" = :b4, "PRINT_COPIES" = :b5 where "REPORT_ID" = :p_pk_col
Error Unable to process update.
OK

There aren't any Longs on this table. I found several bugs in Metalink but none had a solution. See the the following documents in metalink: 4522647, 4574882, 4522648

Anyone have a solution? Can I just log a Tar via metalink? There isn't an option for Apex, so I'm wondering if I should put it under the database.

thanks,
Drew

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 24 2007

Added on Jan 30 2007

#apex-discussions

5 comments

1,837 views