Yes, there is Oracle support for the ANSI INT/INTEGER subtype, but it just means NUMBER(38,0) (a synonym). Are they using the DataMapper?
Roberto On Tue, April 26, 2005 9:19, Ron Grabowski said: > I've been helping on a project using an Oracle 9(?) server. They're > using decimals at the moment for their primary key representation. They > said that Oracle doesn't have an INT datatype and that NUMBER(10) > caused problems. I suggested they use NUMBER(9) so they could map > primary keys to System.Int32. Do you have experience with Oracle > Roberto? Does the missing INT thing sound familiar? Very strange... > > --- Roberto Rabe <[EMAIL PROTECTED]> wrote: >> Oracle-support using the Microsoft provider that you are using became >> a >> little more consistent with the DataMapper 1.1 Alpha build. On that >> note, >> have you tried a decimal type field? (Unfortunately, I can't >> remember if >> that worked with OracleClient in that version of the DataMapper.) >> >> Roberto >> >> >> >> On Mon, April 25, 2005 17:37, Keslar, Jeremy said: >> > I am using Microsoft's Oracle data provider and the DataMapper from >> > iBatisNet release 1.0.1.321. >> > >> > >> > -----Original Message----- >> > From: Roberto Rabe [mailto:[EMAIL PROTECTED] >> > Sent: Monday, April 25, 2005 5:27 PM >> > To: ibatis-user-cs@incubator.apache.org >> > Subject: Re: Cannot widen from target type to primitive type. >> > >> > What provider are you using and what version of the DataMapper? >> > >> > Roberto >> > >> > On Mon, April 25, 2005 17:18, Keslar, Jeremy said: >> >> I am trying to retrieve data from Oracle. Everything is working >> fine >> >> except for the Oracle fields with the type Number (8,2). I have >> tried >> >> changing my data types in the code to double, single, etc, but I >> keep >> >> getting the error "Cannot widen from target type to primitive >> type." >> >> Does anyone have any ideas? >> >> >> >> >> >> >> >> >> >> >> >> Jeremy >> >> >> >> >> > >> > >> > >> >> >
