Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Rayees
Contributor
Contributor

Dynamic Load from File to Oracle Table

Hi All,

 

I have a job that loads from a Delimited File to an Oracle Table . The schema is defined with dynamic data type to load the file . I had selected the batch size option in tOracleOutput component to increase the performance of the load . But i am getting the error as  "ORA-24816 - Expanded non LONG bind data supplied after actual LONG or LOB column" . but if i uncheck the option of batch size from the output component the load goes fine . Can you please suggest on this issue as without batch size option , there is a major hit to the performance of the load .

 

 

Thanks in Advance.

Labels (2)
0 Replies