ORA 12592:TNS:bad packet error

Question

Hi,

I'm trying to load my workflow output to ORACLE table but getting TNS bad packet error. But when i try to load the data to other table i'm not getting any error.

I tried using Block until done before Output but no help. I've tried saving the output as a .csv and then writing this csv to Oracle table but still no help.

I've tried changing to Oracle bulk but then i get "Error running TRUNCATE TABLE" error ( I'm doing delete data and append) and i cannot this permission from my DBA also.

Is there any other way to solve this issue?

Thanks,

Anand

AnandKumar1 · Accepted Answer

There were some NULL value in output but in Oracle DB it was set to not null. So i've asked DB guys to make it Nullable and it works now.