Devart Forums

Posted: **Fri 27 Oct 2017 04:34**

Hi
I want to call an oracle function from entity developer.
I wrote this command in "command text" property:

SELECT FNC_SUM(1,2) 
FROM DUAL

but in running time I got this error:

System.InvalidCastException: 'Invalid cast from 'System.Decimal' to 'System.Data.Metadata.Edm.PrimitiveType'.'

in model designer code:

result = (global::System.Nullable<int>)command.ExecuteScalar();

how to solve this?

Posted: **Wed 01 Nov 2017 13:36**

Please set Return Type = Decimal in CSDL of *.edml via interface of Entity Developer to generate:

result = (global::System.Nullable<decimal>)command.ExecuteScalar();

After this, the code should work.

Orcacle call function error