topic Re: zero-length columns are not allowed in Talend Studio

zero-length columns are not allowed

Anonymous — Tue, 18 Jun 2019 10:18:47 GMT

Exception in component tDBOutput_4 (Invoiced_TM_Rev)
java.sql.SQLException: ORA-01723: zero-length columns are not allowed

How can I resolve this exception?

Re: zero-length columns are not allowed

Ganshyam — Tue, 18 Jun 2019 10:38:10 GMT

Hello,

It seems that the table created is having datatype length as 0.

eg : CHAR(0) or VARCHAR2(0)

Please recheck the table creation script.

Regards

Ganshyam Patel

Re: zero-length columns are not allowed

Anonymous — Tue, 18 Jun 2019 11:10:59 GMT

Re: zero-length columns are not allowed

Anonymous — Tue, 18 Jun 2019 16:12:19 GMT

Hi,

I believe you are creating table in this case.

Could you please add length for all the varchar columns?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: zero-length columns are not allowed

Anonymous — Wed, 19 Jun 2019 05:59:18 GMT

I have added length still getting same error. pl help!

Re: zero-length columns are not allowed

Anonymous — Wed, 19 Jun 2019 06:00:51 GMT

Added Length still getting same error.

action on table - drop table if exist and create -- action on data - insert.

Re: zero-length columns are not allowed

bhagyarekha — Wed, 19 Jun 2019 06:33:21 GMT

Hi Pankaj,

what your status is having?

first try to limit the status for 200 length,as row1.status. substring(0,200) in tmap

if it works fine you can understand the length.

just give a try with this and see.

Regards,

Rekha

Re: zero-length columns are not allowed

Anonymous — Wed, 19 Jun 2019 06:43:12 GMT

200 length is sufficient.

Status and Length
CS Rejected 11
Created 7
Cancelled 9
Draft 5
CS Approved 11
Sent For Approval 17