Page 1 of 1
Mapping difference between Number in Stored Proc and Table
Posted: Tue 02 Jun 2009 13:02
by GlennBA
I am current evaluating dotConnect for Oracle.
It seems to map Number in table to System.Decimal and Number in Stored Proc to System.Double. That is very unfortunate
Best regards
Glenn
Posted: Tue 02 Jun 2009 13:54
by AndreyR
The precision of data type is lost when procedure is described (this is a designed behaviour of the Oracle database).
You can edit data types manually in Entity Developer.
Posted: Tue 02 Jun 2009 14:46
by GlennBA
System.Decimal is not compatible with System.Double which means that Entity Developer generates code which is not compilable when defining Update procedures, for example
Posted: Thu 04 Jun 2009 13:58
by AndreyR
I have just made some simple update tests using procedures and succeeded.
Could you please send me a script of the procedure causing the compilation error?