1 Reply Latest reply: Nov 4, 2013 2:30 AM by Craig RSS

    Loading a CLOB from a CSV file into Oracle

    Craig

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