problems with oci

problems with oci

Postby jahp78 » Wed 27 Apr 2005 16:16

hi , how can i fix the next problem ...
i bought the version 2.5 of Ora Direct Provider and install the provider for the framework 1.x and It install it on windows 2000 advanced

tks

OCI invalid handle. at a.c.q.a(Int32 A_0)
at CoreLab.Oracle.OracleLob.b()
at CoreLab.Oracle.OracleDataReader.Read()
at System.Data.Common.DbDataAdapter.FillLoadDataRow(SchemaMapping mapping)
at System.Data.Common.DbDataAdapter.FillFromReader(Object data, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
at CoreLab.Oracle.OracleDataAdapter.a(DataTable A_0, OracleDataReader A_1, DataSet A_2, String A_3, Int32 A_4, Int32 A_5)
at CoreLab.Oracle.OracleDataAdapter.a(DataSet A_0, String A_1, IDataReader A_2, Int32 A_3, Int32 A_4)
at CoreLab.Oracle.OracleDataAdapter.b(DataSet A_0, String A_1, IDataReader A_2, Int32 A_3, Int32 A_4)
at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at SIEComLib.clsOraDirect.FillDataSet(String xQuery)
jahp78
 

Postby Paul » Thu 28 Apr 2005 07:15

Send us please small demo project to demonstrate the problem and include script to create server objects to OraDirect.Net support address
Paul
 
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Postby Guest » Thu 28 Apr 2005 17:08

I don't understand your reply , con you be more explicit ????
Like a posible solution , I installed the ora direct 3 beta , but at this moment i get the next mistake


Error Aplicacion: Error: ORA-01000: maximum open cursors exceeded
at CoreLab.Oracle.OracleCommand.a(CommandBehavior A_0, IDisposable A_1, Int32 A_2, Int32 A_3)
at CoreLab.Common.DbCommandBase.b(CommandBehavior A_0)
at CoreLab.Common.DbCommand.a(CommandBehavior A_0)
at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at SIEComLib.clsOraDirect.FillDataSet(String xQuery)||SEGURIDAD.PKG_SEGURIDAD.SP_CON_USUARIO_VALIDA||||556944,0,0||1,2,2||200,300,131||

Can i contact you by messanger ??
because i need resolve this problem quickly . I have been follow the examples that come with the provider for to do my connection class thaks ...
Guest
 

Postby Paul » Fri 29 Apr 2005 07:44

You cannot contact us through messenger. We are working through e-mail or
forum. It is hard to reproduce your problem without additional information.
Can you send small working demo project (including SQL scripts for creating
server objects, tables) that demonstrates these problems to OraDirect.Net
support address (o r a n e t @ c r l a b . c o m). We will correct this
problem as soon as possible.
Paul
 
Posts: 725
Joined: Thu 28 Oct 2004 14:06


Return to dotConnect for Oracle