Devart Forums

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

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

Any results regarding this issue?

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

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.

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.

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

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

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.