Oracle Function problem

Discussion of open issues, suggestions and bugs regarding Entity Developer - ORM modeling and code generation tool
Post Reply
kala
Posts: 2
Joined: Wed 20 May 2015 13:23

Oracle Function problem

Post by kala » Wed 20 May 2015 13:36

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.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Oracle Function problem

Post by Shalex » Fri 22 May 2015 09:37

Please send us a small test project with the corresponding DDL/DML script for reproducing.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Oracle Function problem

Post by Shalex » Thu 28 May 2015 11:13

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.

kala
Posts: 2
Joined: Wed 20 May 2015 13:23

Re: Oracle Function problem

Post by kala » Mon 01 Jun 2015 07:12

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 !

Post Reply