Page 1 of 1

Oracle Function problem

Posted: Wed 20 May 2015 13:36
by kala
Hi!

I have an entity developer model (.edml) and I want to use an Oracle scalar function that returns a varchar2.

I followed the steps given in the first answer of this topic: http://forums.devart.com/viewtopic.php? ... 45&p=68200

When I call the method created, an error occurs : System.Data.Entity.Core.EntityCommandExecutionException with this inner exception:
{"ORA-06550: Ligne 1, colonne 8 : PLS-00221: 'MY_FUNCTION' n'est pas une procédure ou est indéfini\nORA-06550: Ligne 1, colonne 8 : PL/SQL: Statement ignored"}

(Means: 'MY_FUNCTION' is not a procedure or is undefined).

Am I doing something wrong or is there another way to call the function?

Thanks.

Re: Oracle Function problem

Posted: Fri 22 May 2015 09:37
by Shalex
Please send us a small test project with the corresponding DDL/DML script for reproducing.

Re: Oracle Function problem

Posted: Thu 28 May 2015 11:13
by Shalex
We have sent a test project to you. If you do not receive it, please check your spam filter and provide us (via contact form) with an alternative email address.

Re: Oracle Function problem

Posted: Mon 01 Jun 2015 07:12
by kala
Hello,

The support sent the project and I understood the problem: my mistake!
I was not using the devart dlls, I just created a devart entity data model and used ODP.net managed driver for EntityFramework. Once I used it the function worked.
Thanks again !