[archive] Acu4gl -error ORA-01776

[Migrated content. Thread originally posted on 02 February 2010]

Hello,

When I try to rewrite or add a record to an exisiting Oracle-table I get error ORA-01776.
Reading and deleting records is not a problem so therefore I think the XFD-file is correct.
When I do the same on an empty database it works fine.
Acu4gl version 8.1
Oracle version 10 or 11.

Need some help please.

Is the table being updated a view? The Oracle error utility (oerr) describes the error as:

01776, 00000, "cannot modify more than one base table through a join view"
// *Cause: Columns belonging to more than one underlying table were either
// inserted into or updated.
// *Action: Phrase the statement as two or more separate statements.

[Migrated content. Thread originally posted on 02 February 2010]

Hello,

When I try to rewrite or add a record to an exisiting Oracle-table I get error ORA-01776.
Reading and deleting records is not a problem so therefore I think the XFD-file is correct.
When I do the same on an empty database it works fine.
Acu4gl version 8.1
Oracle version 10 or 11.

Need some help please.

Is the table being updated a view? The Oracle error utility (oerr) describes the error as:

01776, 00000, "cannot modify more than one base table through a join view"
// *Cause: Columns belonging to more than one underlying table were either
// inserted into or updated.
// *Action: Phrase the statement as two or more separate statements.

[Migrated content. Thread originally posted on 02 February 2010]

Hello,

When I try to rewrite or add a record to an exisiting Oracle-table I get error ORA-01776.
Reading and deleting records is not a problem so therefore I think the XFD-file is correct.
When I do the same on an empty database it works fine.
Acu4gl version 8.1
Oracle version 10 or 11.

Need some help please.

Is the table being updated a view? The Oracle error utility (oerr) describes the error as:

01776, 00000, "cannot modify more than one base table through a join view"
// *Cause: Columns belonging to more than one underlying table were either
// inserted into or updated.
// *Action: Phrase the statement as two or more separate statements.

[Migrated content. Thread originally posted on 02 February 2010]

Hello,

When I try to rewrite or add a record to an exisiting Oracle-table I get error ORA-01776.
Reading and deleting records is not a problem so therefore I think the XFD-file is correct.
When I do the same on an empty database it works fine.
Acu4gl version 8.1
Oracle version 10 or 11.

Need some help please.

We had a similar issue and it turned out to be a bad XFD. We use a utility to modify the XFDs that the compiler generates and that utility wasn't handling the version 6 xfds (which is the default for the 8.1 compiler).