topic Re: [resolved] Talend Bug? Oracle nvl returns emtyp string, and Talend does not in Talend Studio

[resolved] Talend Bug? Oracle nvl returns emtyp string, and Talend does not

Anonymous — Sat, 16 Nov 2024 13:41:38 GMT

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

Re: [resolved] Talend Bug? Oracle nvl returns emtyp string, and Talend does not

Anonymous — Tue, 10 Nov 2009 03:33:22 GMT

Hello Dave
Please check your query statement if it is correct.
On tOracleInput,
"select nvl(null,'') as EmptyString from dual" ==>return null
"select nvl(null,' ') as EmptyString from dual" ==>there is a blank space bettween single quote, return empty string.
Best regards

shong

Re: [resolved] Talend Bug? Oracle nvl returns emtyp string, and Talend does not

Anonymous — Tue, 10 Nov 2009 16:22:23 GMT

Hello Dave
Please check your query statement if it is correct.
On tOracleInput,
"select nvl(null,'') as EmptyString from dual" ==>return null
"select nvl(null,' ') as EmptyString from dual" ==>there is a blank space bettween single quote, return empty string.
Best regards

shong

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

Re: [resolved] Talend Bug? Oracle nvl returns emtyp string, and Talend does not

Anonymous — Wed, 11 Nov 2009 05:11:45 GMT

Hello

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

Re: [resolved] Talend Bug? Oracle nvl returns emtyp string, and Talend does not

Anonymous — Wed, 11 Nov 2009 16:54:29 GMT

Hello

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

oops! Sorry - my bad. Thanks shong.
Dave