https://community.qlik.com/t5/Talend-Studio/Dynamic-Load-from-File-to-Oracle-Table/m-p/2202382#M4102 <P>Hi All,</P><P>&nbsp;</P><P>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&nbsp; "ORA-24816 -&nbsp;<SPAN>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 .</SPAN></P><P>&nbsp;</P><P>&nbsp;</P><P><SPAN>Thanks in Advance.</SPAN></P> Fri, 14 Feb 2020 11:08:09 GMT Rayees 2020-02-14T11:08:09Z https://community.qlik.com/t5/Talend-Studio/Dynamic-Load-from-File-to-Oracle-Table/m-p/2202382#M4102 <P>Hi All,</P><P>&nbsp;</P><P>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&nbsp; "ORA-24816 -&nbsp;<SPAN>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 .</SPAN></P><P>&nbsp;</P><P>&nbsp;</P><P><SPAN>Thanks in Advance.</SPAN></P> Fri, 14 Feb 2020 11:08:09 GMT https://community.qlik.com/t5/Talend-Studio/Dynamic-Load-from-File-to-Oracle-Table/m-p/2202382#M4102 Rayees 2020-02-14T11:08:09Z