Oracle Sp: Getting System.Data.Ole Db.OleDbExcepti on: ̸�

[John G]

I have been using Oracle Helper to connect to my oracle 9i Db. When
excute text it works fine, but when I try to execute a store procedure
I get the following error message. I searched everyplace for a
solution.

System.Data.Ole Db.OleDbExcepti on: ̸�
[OleDbException (0x80004005): ̸�]

System.Data.Ole Db.OleDbCommand .ExecuteCommand TextForMultpleR esults(tagDBPAR AMS
dbParams, Object& executeResult) +161
System.Data.Ole Db.OleDbCommand .ExecuteCommand Text(Object&
executeResult) +160
System.Data.Ole Db.OleDbCommand .ExecuteCommand (CommandBehavio r
behavior, Object& executeResult) +48
System.Data.Ole Db.OleDbCommand .ExecuteReaderI nternal(Command Behavior
behavior, String method) +106
System.Data.Ole Db.OleDbCommand .ExecuteNonQuer y() +108
Here is my code:
string sql = "ghi.usp_Catego ry_Add";

OleDbParameter[] sp = new OleDbParameter[10];
HttpContext.Cur rent.Trace.Writ e("Category",
content.ToStrin g());
sp[0] = new OleDbParameter( "p_Id", content.Id);
sp[0].OleDbType = OleDbType.Integ er;
sp[0].Direction = ParameterDirect ion.InputOutput ;
sp[1] = new OleDbParameter( "p_parentId ", content.ParentI d);
sp[1].OleDbType = OleDbType.Integ er;
sp[2] = new OleDbParameter( "p_name", content.Name);
sp[2].OleDbType = OleDbType.VarCh ar;
sp[3] = new OleDbParameter( "p_description" ,
content.Descrip tion);
sp[4] = new OleDbParameter( "p_priority ", content.Priorit y);
sp[5] = new OleDbParameter( "p_url", content.Url);
sp[6] = new OleDbParameter( "p_ContentI d", content.Content Id);
sp[7] = new OleDbParameter( "p_ShowSubMenu" ,
content.ShowSub Menu);
sp[8] = new OleDbParameter( "p_SideMenu ", content.SideMen u);
sp[9] = new OleDbParameter( "p_user", "john");

OleDbHelper.Exe cuteNonQuery(Se ttings.Connecti onString,
CommandType.Sto redProcedure, sql, sp);
content.Id = FormUtils.Conve rtInt(sp[0].Value.ToString ());