Skip to Main Content
  • Questions

  • Encountering error while loading Data with Toad for oracle

Breadcrumb

Announcement

Free this Wednesday? Looking for some cool tech demos? Come along to our FREE hour of 100% 23ai demo . No slides, no marketing, just all demo.

Question and Answer

Connor McDonald

Thanks for the question, Kevin.

Asked: March 06, 2025 - 7:48 pm UTC

Last updated: March 07, 2025 - 1:40 am UTC

Version: Toad for Oracle 16.3

Viewed 100+ times

You Asked

I was loading Large Data into a newly created table in Toad For Oracle 16.3 using SQL Loader with an Excel Data but i got error "Rejected - Error on table SCH_STRUCT_FIN.OFFSHORE_INV_COMM_MEETING_DATA, column COLLATERAL_FUNDING_REQUIREMENT . Field in data file exceeds maximum length"

and also Record 258: "Rejected - Error on table SCH_STRUCT_FIN.OFFSHORE_INV_COMM_MEETING_DATA, column TRIGGERING_EVENT_FOR_TRUST_CONVERSION.
no terminator found after TERMINATED and ENCLOSED field.



My VARCHAR2 is already set on 4000 but still getting the same error in SQL Loader.


Please help with solution

and Connor said...

See this question

https://asktom.oracle.com/ords/asktom.search?tag=sql-loader-not-loading-if-column-value-in-multiple-lines-and-value-enclosed-in-double-quotes

I suspect your data is not being interpreted correctly and thus sql loader just keeps appending data to an existing field.

But we'd need to see test cases, control files and log files - otherwise we're flying blind
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library