dbTalk Databases Forums  

oracle 10.1 odp.net InvalidCastException on store procedure

comp.databases.oracle.tools comp.databases.oracle.tools


Discuss oracle 10.1 odp.net InvalidCastException on store procedure in the comp.databases.oracle.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
lynne.randolph@gmail.com
 
Posts: n/a

Default oracle 10.1 odp.net InvalidCastException on store procedure - 11-04-2008 , 02:09 PM






I'm using arraybind to perform batch inserts into an Oracle 10.1
database. I'm using the Oracle.DataAccess.dll for 10.1. Most of the
time, the inserts work fine. I have 21 object arrays that are passed
as parameters to the stored procedure which does a database insert.
Currently, my arrays are of size 5000 and I'm performing the batch
insert about every 1-2 minutes. Occasionally, and I'd say maybe once
every couple of hours, I get this exception:

System.InvalidCastException: Unable to cast object of type
'System.Object[]' to type 'System.IConvertible'.
at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQ uery()
at gov.its.dataArchive.ods.OdsDbTss.doBatchPollInsert () in C:
\Projects\FDOT\SG-4.0-Dev\SourceCode\dataArchive\DataArchiveLib\ods
\OdsDbTss.cs:line 1087
at gov.its.dataArchive.ods.OdsDbTss.doRollup(DateTime time) in C:
\Projects\FDOT\SG-4.0-Dev\SourceCode\dataArchive\DataArchiveLib\ods
\OdsDbTss.cs:line 1273

Does anyone know why this might occur sporadically?

Thanks,

Lynne

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.