oracle.dataaccess.client blob,Oracle.DataAccess.Client.OracleException ORA-29875 - ODCIINDEXINSERT e...

Hi,

We are migrating data into our GIS repository using an application witch uses ODP fro .NET.

Yesterday, when we were importing parcels from a certain geographic zone we have got this error:

4430528 [4028] ERROR DBCommand - Error Executing Command [PARCELA.WRITE]

Parameters:

ResValue: [Int32]

POP_ID: [Int64]35397

PAR_ID: [Varchar2]

BLO_ID: [Decimal]836170

PAR_NUM: [Varchar2]1480296132900

geometry: [Blob]System.Byte[]

PAR_PON_ETI: [Blob]System.Byte[]

Oracle.DataAccess.Client.OracleException ORA-29875: failed in the execution of t

he ODCIINDEXINSERT routine

ORA-29400: data cartridge error

ORA-14450: attempt to access a transactional temp table already in use

ORA-06512: at "MDSYS.SDO_IDX", line 161

ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 332

ORA-06512: at "SIG.PARCELA", line 354

ORA-06512: at "SIG.PARCELA", line 479

ORA-06512: at line 1 at pt.inga.db.Command.Execute(IDbConnection connection,

IDbCommand command, Boolean& closeConnection) in C:\code-base\inga\isig\src-1.0.

0.2\pt\inga\db\Command.cs:line 234

at pt.inga.db.Command.Execute(IDbConnection connection, OracleCommand command

, IDataRecord parentRecord, IDataRecord dataRecord, IOperationData operation, Bo

olean& closeConnection) in C:\code-base\inga\isig\src-1.0.0.2\pt\inga\db\Command

.cs:line 334

The error seems to be related with temporary tables manipulation, does it?

Has we didnât know what to do we try to import those parcels after dropping a spatial index over the parcelâs table and we succeed with the import.

Those any one has any ideas about this?

And about spatial indexes internals?

Thanks in advance,

Vitor

Versions:

Client: Oracle10g Data Provider for .NET 10.1.0.2.0

Clientâs OS:Windows 2003 server

Server: Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

Serverâs OS:AIX 5.2.0.0