Forum Stats

  • 3,837,059 Users
  • 2,262,222 Discussions


Loading a CLOB from a CSV file into Oracle

Craig Member Posts: 14
edited Nov 4, 2013 3:30AM in Data Integrator

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



This discussion has been closed.