zero-length columns are not allowed

[Anonymous]

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?

[Ganshyam]

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

[Anonymous]

[Anonymous]

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 🙂

[Anonymous]

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

[Anonymous]

Added Length still getting same error. 

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

[bhagyarekha]

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

[Anonymous]

200 length is sufficient.

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