https://community.qlik.com/t5/Talend-Studio/tOracleOutput-and-default-length-precsion/m-p/2301855#M73897 Hi Talendforge, <BR />Using TOS 3.1.0, I accounter a problem with tOracleOutput and the default NUMBER length and precision when left blank in a filed which I expect to be blank in the generated request. <BR />Instead I have a request with NUMBER(0,0) which is rejected by Oracle itself. the length should be between 1 and 38 (ORA-01727) <BR />I am using a modified table schema from the database which contains this field, which is connected to the tOracleOutput component. <BR />other cases exists but this is what I have in mind that causes my actual problem. <BR />is it a bug or am i doing something wrong? Sat, 16 Nov 2024 13:57:25 GMT Anonymous 2024-11-16T13:57:25Z https://community.qlik.com/t5/Talend-Studio/tOracleOutput-and-default-length-precsion/m-p/2301855#M73897 Hi Talendforge, <BR />Using TOS 3.1.0, I accounter a problem with tOracleOutput and the default NUMBER length and precision when left blank in a filed which I expect to be blank in the generated request. <BR />Instead I have a request with NUMBER(0,0) which is rejected by Oracle itself. the length should be between 1 and 38 (ORA-01727) <BR />I am using a modified table schema from the database which contains this field, which is connected to the tOracleOutput component. <BR />other cases exists but this is what I have in mind that causes my actual problem. <BR />is it a bug or am i doing something wrong? Sat, 16 Nov 2024 13:57:25 GMT https://community.qlik.com/t5/Talend-Studio/tOracleOutput-and-default-length-precsion/m-p/2301855#M73897 Anonymous 2024-11-16T13:57:25Z