1 Reply Latest reply on Nov 4, 2013 8:30 AM by Craig

    Loading a CLOB from a CSV file into Oracle


      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)"