0
Answer

How to call oracle stored procedure which returns cursor

Hi,

I am developing application with silverlight 5, RIA Services and Entity Framework.I am using oracle 11g database. Now my requirement is i have to call a stored procedure which returns cursor. One process is we have to give oracle client settings to create complex type in config file like
<oracle.dataaccess.client>
    <settings>
      <add name="HR.UPDATE_AND_RETURN_SALARY.RefCursor.NEW_SALARY" value="implicitRefCursor bindinfo='mode=Output'" />
      <add name="HR.UPDATE_AND_RETURN_SALARY.RefCursorMetaData.NEW_SALARY.Column.0" value="implicitRefCursor metadata='ColumnName=FIRST_NAME;BaseColumnName=FIRST_NAME;BaseSchemaName=HR;BaseTableName=EMPLOYEES;NATIVEDATATYPE=Varchar2;ProviderType=Varchar2'" />
      <add name="HR.UPDATE_AND_RETURN_SALARY.RefCursorMetaData.NEW_SALARY.Column.1" value="implicitRefCursor metadata='ColumnName=SALARY;NATIVEDATATYPE=Number;ProviderType=Int32'" />
    </settings>
  </oracle.dataaccess.client>

what is the other way to do it from model.edmx..?