Just as it is explained in: http://forum.hibernate.org/viewtopic.php?p=2397111 http://xmlguy.wordpress.com/2008/04/11/nhibernate-tales-n2-mapping-oracle-number-decimal/
you have to use the formula property to trunc the value. In AR, you define the formula as a property of the PropertyAttribute, see: http://www.castleproject.org/ActiveRecord/documentation/trunk/manual/attributedocs/Generated_PropertyAttribute.html#PropertyAttribute_Properties On Mar 16, 10:49 am, cameron <[email protected]> wrote: > All, > > I am fairly new to the Castle ActiveRecord project, but I feel I have > a pretty good grasp of how everything works. With that, I am running > into an error message that I cannot seem to figure out. I have > searched far and wide on the web and in this group for an answer, but > havent found anything. > > The problem: > Data stored in the Number oracle data type is receiving an OCI-22053: > overflow error when mapping to a .net decimal datatype. It works fine > when the value is 0, but any other value I get the oracle error > (Examples of the values throwing the error: > 20.8996774193548,37.8983333333333,165.791142857143). These should > easily fit into the decimal datatype. > > The one suggestion I could find was to use the oracle trunc function, > but I am not sure how to implement that using the AR framework. Any > help is appreciated, I really want to use this framework, but may have > to go elsewhere. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Castle Project Users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/castle-project-users?hl=en -~----------~----~----~----~------~----~------~--~---
