Hi Walaa,
Thanks for the response to Sabina's question.
As some additional information for her question, we have been using the following post as our guideline of how to specify the size of Oracle fields, so they properly come up as the specific .NET data types we need (e.g. decimal, int32, int 16, float).
http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=897&HighLight=1
A couple reasons we need to make sure we get this right:
*Due much of our data being monetary, we really need to use decimal data types, instead of floating datatype.
*We create parallel LLBLGen layers for Oracle and SQL Server (customer option which they want to use on their server), so we need to make sure we have the matching datatypes in both the Oracle and SQL Server database.
From what I understand from this posting, the Oracle source code fragment Frans posted is how the Oracle ODP.NET driver determines which datatype to return the data as.
Sure, we can run some tests if needed. But our question is really if you guys know if this posting information is still accurate, or has changed since 2004? If it's changed, might you have an idea of which version it changed in...or if you think (like was available 10 years ago) Oracle might still give access to seeing how their ODP.NET driver is deciding in which datatype their driver returns the data.
Thanks!