This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The Input Data or Connect In-DB tool will populate numeric values with "[Null]" instead of a blank cell. Querying with other tools such as SQL Developer show blank cells.
Driver version 12.02
Region or NLS_LANG conflicts.
In the ODBC DSN configuration page for the Oracle ODBC driver used for the connection in Designer, select the option "Use Microsoft regional settings" for the Numeric Settings option. Recreate the Input or In-DB connection and re-test.