Hi folks,
I got a problem with a database import from an ms-access database, when using more than one CLOB-column.
I created an ODBC-connection to the access-db, so I can use the COPY-command to import the data to an existing oracle-db. This works very well. But the problem concerns memo-fields from the access-db. I defined those fields as CLOBs in oracle, because one table needs more than one columns of this type. The COPY-command is restricted to use only one CLOB-column per statement. So I first filled my oracle-table with only one CLOB-column, copied the second CLOB-column and the primary key columns into a temp. table and tired then to update my oracle-table, but then I get an ORA-Message "inconsistent datatypes". In the temp. table the memo-field is stored as "long" datatype, but in the COPY-command I use the function TO_LOB() to convert it to a CLOB, which works well for the first column, but not for the second.
Any help or comments would be appreciated.
Regards