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.
Oracle Function problem
Re: Oracle Function problem
Please send us a small test project with the corresponding DDL/DML script for reproducing.
Re: Oracle Function problem
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
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 !
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 !