The destination Oracle table must exist prior to using SQLLoader to load the CTL file. FME will not create the required table.
If the table does not exist, then it can be created by opening the CTL file that FME generated. In the comments section is the SQL statement that will create the table with the correct structure.
To use this SQL:
- Log into SQLPlus.
- Copy the SQL from the CTL file (do not include the comment marks, but do include the semi-colon at the end).
- Paste the string into SQLPlus.
- Through Oracle’s SQLLoader interface, load the data from the CTL file into the newly created table.