Hello, I was in the process of retrofitting Transfer ORM to a set of existing tables. There was a onetomany link in the query and the system ran but gave the following error.
SQLState: 42000 ErrorCode: 907 Position: 792 Error: ORA-01790: expression must have same datatype as corresponding expression SQLState: 42000 ErrorCode: 1790 Position: 270 I investigated this further and found it was a difference between character and numeric data for the key. (I know, I know, this was inherited software soo....) I was able to 'fix' the query by adding to_char() to the key field in question. I am going to migrate the data to 'all strings'. I do not know if this was previously reported, I don't know if it is worth fixing, but I just wanted to pass it along. Thanks for providing the tool. --~--~---------~--~----~------------~-------~--~----~ Before posting questions to the group please read: http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer You received this message because you are subscribed to the Google Groups "transfer-dev" group. To post to this group, send email to transfer-dev@googlegroups.com To unsubscribe from this group, send email to transfer-dev-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en -~----------~----~----~----~------~----~------~--~---