You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » String "null" instead of NULL in a varchar column
#1 2010-02-11 13:36:06
- hrueger
- Member
- Registered: 2009-10-02
- Posts: 48
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
Offline
#2 2010-02-15 15:03:34
- hrueger
- Member
- Registered: 2009-10-02
- Posts: 48
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
Offline
#3 2010-02-18 17:30:54
- hrueger
- Member
- Registered: 2009-10-02
- Posts: 48
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/viewto … 345#p37345
Regards Hartmut
Offline
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » String "null" instead of NULL in a varchar column