In a TOracleInput, I am getting back null in talend, when I should be getting back an empty string:The following is an illustration of source SQL for Oracle in a tOracleInput"select nvl(null,"'" + "'" + ") as EmptyString from dual"Oracle returns an empty string, and NOT null. Talend should receive it as an empty string.Am I missing something?Dave

shong,With no space between the single quotes, oracle returns an empty string, not a null. See screenshot below.The problem (seems like a talend bug to me), is that talend shows the retreived data as null, when I show it in a msgbox.Dave

With no space between the single quotes, oracle returns an empty string, not a null. See screenshot below.

If you execute it as query statement(press F9 in Oracle sql developer), you will see it return null on result viewer. Anyway, you could get null without space bettween single quote or empty string with space bettween single quote in Talend.Best regards

shong

----------------------------------------------------------Talend | Data Agility for Modern Business

With no space between the single quotes, oracle returns an empty string, not a null. See screenshot below.

If you execute it as query statement(press F9 in Oracle sql developer), you will see it return null on result viewer. Anyway, you could get null without space bettween single quote or empty string with space bettween single quote in Talend.Best regards