BINARY_INTEGER and/or PLS_INTEGER in stored procedure parameters

[ender]

How OraDirect.NET handle BINARY_INTEGER or PLS_INTEGER when they encountered in a stored procedure parameter list? I mean following procedure declaration:

Code: Select all

create or replace procedure Test(Value1 in pls_integer, ...

I'm tried to use such procedures in Delphi 2005 with ADO.NET and received parameters with type ftInterface. It seems even Borland don't know how to work with parameters of this type. What about OraDirect.NET?

[Paul]

Use OracleDbType.Integer type for these parameters. Use oracleCommand1.CreateParameters(); for automatically creation of parameters collection

Code: Select all

      oracleCommand1.CommandText = "Test";
      oracleCommand1.CommandType = CommandType.StoredProcedure;
      oracleCommand1.Parameters.Add("Value1", OracleDbType.Integer);
      oracleCommand1.ExecuteNonQuery();