trailing null missing from STR bind value Error

kulmam · Post by **kulmam** » Mon 05 Jun 2006 08:22

I break the multi-lined text into single lines using following source and insert them into a table using array DML.
However I encounterd the error message at the bottom.
Can you help me out ?
I'm using Oracle 9i and it's charactor set is KO16KSC5601.

if( sSrc.Length > 4000 )
{
int nSeq = 1;
int nCursor = 0, j = 0 ;
char[] buff = sSrc.ToCharArray();
for( j=nCursor; j<sSrc.Length; j++ )
{
if( buff[j] == '\n' )
{
WorkItem workItem = new WorkItem();
workList.Add( workItem );
for( int i=0; i<reader.FieldCount; i++ )
{
int len = (j-nCursor) + 1;
if( i == 5 )
{
workItem.fieldValueList.Add( sSrc.Substring( nCursor, len ) );
}
else if( i == 1 )
{
workItem.fieldValueList.Add( nSeq.ToString() );
}
else
{
workItem.fieldValueList.Add( reader.ToString() );
}
}
nCursor = j+1;
nSeq++;
}
}

if( j == sSrc.Length )
{
int len = sSrc.Length - nCursor;
WorkItem workItem = new WorkItem();
workList.Add( workItem );
for( int i=0; i<reader.FieldCount; i++ )
{
if( i == 5 )
{
workItem.fieldValueList.Add( sSrc.Substring( nCursor, len ) );
}
else if( i == 1 )
{
workItem.fieldValueList.Add( nSeq.ToString() );
}
else
{
workItem.fieldValueList.Add( reader.ToString() );
}
}
}
}

Code : 24381, LineNumber : 0, LinePosition : 0, Message : ORA-24381: error(s) in array DML
2. Code : 1480, LineNumber : 0, LinePosition : 0, Message : ORA-01480: trailing null missing from STR bind value
3. Code : 3106, LineNumber : 0, LinePosition : 0, Message : ORA-03106: fatal two-task communication protocol error

Alexey · Post by **Alexey** » Tue 06 Jun 2006 07:24

Please send us small test project to reproduce the problem; include definition of your own database objects. Do not use third party components.

Alladin · Post by **Alladin** » Mon 26 Jan 2009 17:07

Any results regarding this issue?

It seems that we are experiencing the same problem but with Euro encoding

Shalex · Post by **Shalex** » Tue 27 Jan 2009 11:48

Alladin, could you please provide us with the following information?
1. Version of dotConnect for Oracle. You can see it in Tools | Oracle | About menu of Visual Studio.
2. Version of your Oracle server and client you are using.
3. Version of your operating system.
4. A detailed problem description and the full text of the error you are getting.
5. Please send me (alexsh*devart*com) a small test project that reproduces the problem. Please include definitions of database objects and avoid using third-party components.

Alladin · Post by **Alladin** » Thu 19 Feb 2009 12:58

We can easily reproduce this error on any database. This is definitely a bug.

1. It works only in Unicode mode.
2. It works only if command executed more than once.

I just send you the project to reproduce this bug.

Shalex · Post by **Shalex** » Mon 23 Feb 2009 11:24

The problem is fixed. Look forward to the next build of dotConnect for Oracle.

pedro.castelo · Post by **pedro.castelo** » Thu 04 Mar 2010 16:08

Hi,
I'm using the version 4.75.43.0 of CoreLab.oracle and I'm getting exactly same error..
The problem is that my subscription is over and I cannot download the corrected version. Is there any other way?

Kind regards,
Pedro

Shalex · Post by **Shalex** » Fri 05 Mar 2010 12:38

Please try the latest 5.60.102 trial version of dotConnect for Oracle to check if the problem is fixed. You can download it from our download page.

Devart Forums

trailing null missing from STR bind value Error

trailing null missing from STR bind value Error

ORA-01480 on v4.75.43.0(Corelab.Oracle)