I'm consuming data files from a third party and I need to load them into an Oracle database. One of the files has a field that's described in the data dictionary as varchar2(8000) which will obviously need to be stored as a CLOB.
I have two questions:
1. How do I create a Model for the data file when CLOB isn't available as the Type of a column.
2. Will I need to do anything fancy to get it into a CLOB column in an Oracle table? I'm using "LKM File to Oracle (SQLLDR)" and "IKM Oracle Incremental Update (PL SQL)"