https://community.qlik.com/t5/Data-Quality/Create-table-varchar2-x-char-at-run-time-in-talend/m-p/2205457#M818 <P>Ther is no solution, why you are adding link that is not solving anything? </P> Fri, 09 Dec 2022 11:43:05 GMT Pawel_M 2022-12-09T11:43:05Z https://community.qlik.com/t5/Data-Quality/Create-table-varchar2-x-char-at-run-time-in-talend/m-p/2205455#M816 <P>Hi All,</P><P></P><P></P><P>How to create table varchar2( x char) at run time in talend.</P><P>In talend it is creating varchar2(x byte).</P> Sat, 16 Nov 2024 00:03:35 GMT https://community.qlik.com/t5/Data-Quality/Create-table-varchar2-x-char-at-run-time-in-talend/m-p/2205455#M816 sreenivasulu56 2024-11-16T00:03:35Z https://community.qlik.com/t5/Data-Quality/Create-table-varchar2-x-char-at-run-time-in-talend/m-p/2205456#M817 <P>Hello,</P><P>For your requirement, please have a look at this related topic: <A href="https://community.talend.com/s/question/0D53p00007vCspMCAS/how-to-use-varchar2-x-char-datatype-insteat-of-varchar2x-byte" alt="https://community.talend.com/s/question/0D53p00007vCspMCAS/how-to-use-varchar2-x-char-datatype-insteat-of-varchar2x-byte" target="_blank">https://community.talend.com/s/question/0D53p00007vCspMCAS/how-to-use-varchar2-x-char-datatype-insteat-of-varchar2x-byte</A></P><P>Let us know if it helps,</P><P>Best regards</P><P>Sabrina</P> Wed, 16 Jun 2021 02:28:10 GMT https://community.qlik.com/t5/Data-Quality/Create-table-varchar2-x-char-at-run-time-in-talend/m-p/2205456#M817 Anonymous 2021-06-16T02:28:10Z https://community.qlik.com/t5/Data-Quality/Create-table-varchar2-x-char-at-run-time-in-talend/m-p/2205457#M818 <P>Ther is no solution, why you are adding link that is not solving anything? </P> Fri, 09 Dec 2022 11:43:05 GMT https://community.qlik.com/t5/Data-Quality/Create-table-varchar2-x-char-at-run-time-in-talend/m-p/2205457#M818 Pawel_M 2022-12-09T11:43:05Z https://community.qlik.com/t5/Data-Quality/Create-table-varchar2-x-char-at-run-time-in-talend/m-p/2205458#M819 <P>to fix that </P><P>just after creating an Oracle connection with On success add the tDBRow reuse connection </P><P>as SQL :</P><P>"alter session set nls_length_semantics='char'"</P><P> than on success start, your desired flow with reusing oracle </P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000aF99BAAS.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/145128i2324FD59DD5B2BBD/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000aF99BAAS.png" alt="0695b00000aF99BAAS.png" /></span></P> Fri, 09 Dec 2022 11:47:49 GMT https://community.qlik.com/t5/Data-Quality/Create-table-varchar2-x-char-at-run-time-in-talend/m-p/2205458#M819 Pawel_M 2022-12-09T11:47:49Z