14 Replies Latest reply on Aug 28, 2008 8:36 AM by apodictus

    ORA-01790: expression must have same datatype as corresponding expression

    443798
      Hi,

      We've just add some new tables to a new schema in our workspace.
      I've created a tabular form based on one of the new tables and when I attempt to add a row I get the error

      ORA-01790: expression must have same datatype as corresponding expression
      Add Row

      In the reports column attributes each columns reference table owner is our original schema, not the new one, the table name and column name are correct.
      When I change all table owners to the new schema the error still persists.

      If I create a form on a table with report using the wizard it works ok on the new tables.

      I noticed another thread along the same lines, where they created a new workspace for their new tables. I'd rather not go down that path if possible.

      Any help appreciated.

      HTMLDB: 1.6.0.00.87

      Cheers Greg