OraclePackage.ExecuteProcedure don't work

[clark]

Hi
I have script:

Code: Select all

 
procedure Test(TypeName out varchar2) is
  begin
    select NSI_ATTRIBUTE_TYPE_NAME 
      into TypeName 
    from NSI_ATTRIBUTE_TYPES 
    where NSI_ATTRIBUTE_TYPE_ID = 2;
  end;

I have C#-code:

Code: Select all

OraclePackage package = new OraclePackage();
package.PackageName = "PKGCONFIG";
package.Connection = myConnection;

package.Connection.Open();
OracleParameterCollection parameterCollection = package.DescribeProcedure( "Test" ); // - works

package.ExecuteProcedure( "Test", parameterCollection, true ); // exception - wrong number or types of arguments in call to 'TEST'

string myString = (string)parameterCollection["TYPENAME"].Value;
package.Connection.Close();

Thank's

[Paul]

We reproduced your problem and fixed it. This fix will be included in the next OraDirect .NET build.