tags:

views:

259

answers:

1

Is there a way to use positional parameters when calling Oracle stored procedure using System.Data.OracleClient?

IDataParameter parameter = dbCommand.CreateParameter( );
parameter.Value = "Blah Blah";
parameter.Type = OracleType.Varchar;
dbCommand.Parameters.Add(parameter);

The code above creates a parameter and assigns "Parameter1" name to it. When stored proc is called Oracle gives "wrong number or types of arguments" error.

+1  A: 

Solved problem by switching to provider from Oracle (Oracle.DataAccess)

Dmitriy Shvadskiy