[Mono-dev] Re: [Mono-devel-list] TimeStamp support on oracle...

[Hubert FONGARNAND]

Le Jeudi 11 Août 2005 04:10, vous avez écrit :
> Hello Hubert,
>
> I committed to svn trunk HEAD support for Oracle TIMESTAMP using an
> OciDateTime descriptor.
> It is svn revision 48254.

Ok i'm back from my holidays... that's why i've not answered before...
So I've update my mono from svn	and i run a little test : 

		cmd.Connection=new OracleConnection(cnx);
		cmd.CommandText="SELECT datetime FROM essai";
		OracleDataAdapter dta=new OracleDataAdapter(cmd);
		DataSet ds = new DataSet();
		dta.Fill(ds,"TABLE");
		Console.WriteLine("OK");
		foreach(DataRow row in ds.Tables["TABLE"].Rows)
		{
			Console.WriteLine(row["DATETIME"]);
		} 
I get :
*** glibc detected *** free(): invalid pointer: 0x082fe20c ***
Abandon

It fails when it does dta.Fill
When i do a mono --trace the last line i get is :
. . . . . . . . . . ENTER: 
System.Data.OracleClient.Oci.OciDefineHandle:Dispose (bool)(this:0x5cf00
[System.Data.OracleClient.Oci.OciDefineHandle sqlserver.exe], 1, )
. . . . . . . . . . . ENTER: (wrapper managed-to-native) 
System.Runtime.InteropServices.Marshal:FreeHGlobal (intptr)(0x82ff9f4, )






>
> Please let me know if this works for you or not.
>
> Thanks,
> Daniel
>
> Hubert FONGARNAND wrote:
> >I really need the new TimeStamp type (supported starting from oracle 9).
> > It's a MS.NET supported type (i've made tests)...
> >I've begin to do a little patch (attached) to add the timestamp type to
> >oracle.client...
> >but... I've a strange error when i try to do a Fill, it failed with:
> >
> >Unhandled Exception: System.Data.OracleClient.OracleException:
> >in <0x0013d> System.Data.OracleClient.Oci.OciStatementHandle:Fetch ()
> >in <0x0002c> System.Data.OracleClient.OracleDataReader:Read ()
> >in <0x002f4> System.Data.Common.DbDataAdapter:FillTable
> > (System.Data.DataTable dataTable, IDataReader dataReader, Int32
> > startRecord, Int32 maxRecords, System.Int32 counter)
> >in <0x0011f> System.Data.Common.DbDataAdapter:Fill (System.Data.DataSet
> >dataSet, System.String srcTable, IDataReader dataReader, Int32
> > startRecord, Int32 maxRecords)
> >in <0x000d5> System.Data.Common.DbDataAdapter:Fill (System.Data.DataSet
> >dataSet, Int32 startRecord, Int32 maxRecords, System.String srcTable,
> >IDbCommand command, CommandBehavior behavior)
> >in <0x00044> System.Data.Common.DbDataAdapter:Fill (System.Data.DataSet
> >dataSet)
> >in <0x007b8> ConsoleIntranet.Class1:TestTimestamp ()
> >in <0x00015> ConsoleIntranet.Class1:Main (System.String[] args)
> >
> >Could someone help me how to resolve this issue?