IDbDataparameter to use datatable as a return type
<p>I am trying to use the IDbConnection interface to call a stored procedure to return a table type. The database is an orcale database. </p>

<p>C# code</p>

<pre><code>IDbConnection connection = DBFactory.CreateConnection();
connection.Open();
using (IDbCommand comm = connection.CreateCommand())
{
    comm.CommandType = CommandType.StoredProcedure;
    comm.CommandText = STORE_PROC;
    IDbDataParameter param = comm.CreateParameter();
    param.ParameterName = "P_INPUT";
    param.DbType = DbType.String;
    param.Value = "val";

    IDbDataParameter paramOut = comm.CreateParameter();     
    paramOut.ParameterName = "P_OUTPUT";
    paramOut.Direction = ParameterDirection.Output;

    comm.Parameters.Add(param);
    comm.Parameters.Add(paramOut);
    comm.ExecuteNonQuery();
}
</code></pre>

<p>att the line comm.ExecuteNonQuery() I get the following error:</p>

<pre><code>ORA-06550: Regel 1, kolom 7:
PLS-00306: wrong number or types of arguments in call
to 'name_stored_procedure'.
ORA-06550: Regel 1, kolom 7:
PL/SQL: Statement ignored
</code></pre>

<p>the stored procedure function has the following structure:</p>

<pre><code>procedure name_stored_procedure
( p_input       varchar2
, p_output               out   bes_bpr_tabtype
);
</code></pre>

<p>How can i get the command to return the table type?</p>