String "null" instead of NULL in a varchar column

One Star

String "null" instead of NULL in a varchar column

Hello,

i call a stored procedure with the component tOracleSP and give some columns of my schema (main row) as input parameters to the procedure.

The procedure uses the values for inserting a new record into an table.

The result is, that in the columns of datatype varchar2 i do not get a NULL if the corresponding schema column is empty but i get a string "null" instead.

How can i get a NULL instead of this string "null"?

Many thanks in advance for any help.

Regards Hartmut
One Star

Re: String "null" instead of NULL in a varchar column

Hello,

does nobody has an idea how to avoid this "null" strings in columns of type varchar2 in the database?

I think i have to change something in the way to address the database, e.g. the jdbc driver.
But i have not much experience with java.

Many thanks in advance for any help.

Regards Hartmut
One Star

Re: String "null" instead of NULL in a varchar column

Hello,

i have found the reason for the "null" strings:

See: http://www.talendforge.org/forum/viewtopic.php?pid=37345#p37345

Regards Hartmut

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Have you checked out Talend’s 2019 Summer release yet?

Find out about Talend's 2019 Summer release

Blog

Talend Summer 2019 – What’s New?

Talend continues to revolutionize how businesses leverage speed and manage scale

Watch Now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog