ERROR [HY105] [ODBC driver for Oracle] Invalid parameter type

Need help getting back a resultset from an oracle stored procedure

I'm trying to execute an oracle stored procedure which returns an array of
type varchar and I'm getting an error on the calling side reading:

ERROR [HY105] [Microsoft][ODBC driver for Oracle]Invalid parameter type

I'm calling the stored procedure from a c# program using odbc
The oracle version is 9i release 9.2.0.4,
the .net framework version is v1.1.4322
Microsoft.Data.Odbc.dll version 1.0.4030.0

the error message points to the invoking of the fill method
objConn = new OdbcConnection( sConnString );

OdbcCommand objCmd = new OdbcCommand( "{ CALL packageName.spName(?,?) }",
objConn );
objCmd.CommandType = CommandType.StoredProcedure;

OdbcParameter objParm = objCmd.Parameters.Add( "@p_last_name",
OdbcType.VarChar, 50 );
objParm.Value = sLastName.ToUpper();
objParm = objCmd.Parameters.Add( "@p_xmlString", OdbcType.VarBinary, 800 );
objParm.Direction = ParameterDirection.Output;

OdbcDataAdapter objDataAdapter = new OdbcDataAdapter();
objDataAdapter.SelectCommand = objCmd;

objConn.Open();

DataSet objDS = new DataSet();
objDataAdapter.Fill( objDS, 1, 10, "sample" );

within the package spec:

TYPE txmlString is TABLE of VARCHAR2(800) INDEX BY BINARY_INTEGER;

PROCEDURE spName( p_last_name IN VARCHAR, p_xmlString OUT txmlString );


thanks



.

Relevant Pages