OraclePackage.ExecuteProcedure don't work

OraclePackage.ExecuteProcedure don't work

Postby clark » Tue 14 Feb 2006 05:48

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
clark
 
Posts: 6
Joined: Tue 07 Feb 2006 04:27

Postby Paul » Tue 14 Feb 2006 08:43

We reproduced your problem and fixed it. This fix will be included in the next OraDirect .NET build.
Paul
 
Posts: 725
Joined: Thu 28 Oct 2004 14:06


Return to dotConnect for Oracle