oracle - PLS-00306: wrong number or types of arguments in .NET Entity Framework -

oracle - PLS-00306: wrong number or types of arguments in .NET Entity Framework -

i using oracle 11 g edm (using odp.net). oracle sp returns ref cursor , not able run edm. have created complex type , added function import sp selecting homecoming value complex type.

once run application, next error:

ora-06550: line 1, column 8: pls-00306: wrong number or types of arguments in phone call 'getscriptdetail'. ora-06550: line 1, column 8: pl / sql: statement ignored

my app.config :

add name="system.getscriptdetail.refcursor.cv_1" value="implicitrefcursor bindinfo='mode=output'"

add name="system.getscriptdetailbyaitid.refcursormetadata.cv_1.column.0" value="implicitrefcursor metadata='columnname=title;basecolumnname=title;nativedatatype=varchar2;providertype=varchar2'"

my function import contains :

public objectresult<getscriptdetail_result> getscriptdetail(nullable<global::system.decimal> v_id) { objectparameter v_idparameter; if (v_id.hasvalue) { v_idparameter = new objectparameter("v_id", v_id); } else { v_idparameter = new objectparameter("v_id", typeof(global::system.decimal)); } homecoming base.executefunction<getscriptdetail_result>("getscriptdetail", v_idparameter); }

it thorwing exception "return base.executefunction("getscriptdetail", v_idparameter); "

my oracle sp parameter as: v_id in number default null , cv_1 out sys_refcursor

how can pass refcursor output executefuction paramter ? or required pass paramter ?

you need add together next in .config file

<oracle.manageddataaccess.client> <version number="*"> <implicitrefcursor> <storedprocedure schema="schemaname" name="getscriptdetail"> <refcursor name="cv_1"> <bindinfo mode="output" /> </refcursor> </storedprocedure> </implicitrefcursor> </version> </oracle.manageddataaccess.client>

i've found steps here can semi automatically in vs directly: http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/12c/r1/appdev/dotnet/entityframeworkobe/entityframeworkobe.html#section5

now problems schema name beingness everywhere in configuration , edmx, , haven't found decent way create dynamic.

oracle entity-framework-4