Error ORA-01790: expression must have same datatype as corresponding expres
Hello All,
I need help with the last piece of this puzzle. I need to get the add row function working for a tabular form on a view. I have removed all of the automatic DML processes because they don't work with a view joining 2 tables and replaced them with my own pl/sql.
My view simply joins 2 tables to get a name from the joined table. I need to display that name to the user instead of the underlying id.
I still have the default add row process from creating the tabular form. I suspect that this is doing a "union all" and there is some sort of conversion that is failing. Do I need to put in my own select with the union all? If so, how do I do it? Any help at all would be greatly appreciated. I have spent lots of time trying to get this working and still can't finish it.
TIA.