This discussion is archived
1 Reply Latest reply: Nov 4, 2013 12:30 AM by Craig RSS

Loading a CLOB from a CSV file into Oracle

Craig Newbie
Currently Being Moderated

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points