By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,992 Members | 891 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,992 IT Pros & Developers. It's quick & easy.

Oracle Sp: Getting System.Data.OleDb.OleDbException: ̸Ώ

P: n/a
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.OleDb.OleDbException: ̸Ώ
[OleDbException (0x80004005): ̸Ώ]

System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orMultpleResults(tagDBPARAMS
dbParams, Object& executeResult) +161
System.Data.OleDb.OleDbCommand.ExecuteCommandText( Object&
executeResult) +160
System.Data.OleDb.OleDbCommand.ExecuteCommand(Comm andBehavior
behavior, Object& executeResult) +48
System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior
behavior, String method) +106
System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +108
Here is my code:
string sql = "ghi.usp_Category_Add";

OleDbParameter[] sp = new OleDbParameter[10];
HttpContext.Current.Trace.Write("Category",
content.ToString());
sp[0] = new OleDbParameter("p_Id", content.Id);
sp[0].OleDbType = OleDbType.Integer;
sp[0].Direction = ParameterDirection.InputOutput;
sp[1] = new OleDbParameter("p_parentId", content.ParentId);
sp[1].OleDbType = OleDbType.Integer;
sp[2] = new OleDbParameter("p_name", content.Name);
sp[2].OleDbType = OleDbType.VarChar;
sp[3] = new OleDbParameter("p_description",
content.Description);
sp[4] = new OleDbParameter("p_priority", content.Priority);
sp[5] = new OleDbParameter("p_url", content.Url);
sp[6] = new OleDbParameter("p_ContentId", content.ContentId);
sp[7] = new OleDbParameter("p_ShowSubMenu",
content.ShowSubMenu);
sp[8] = new OleDbParameter("p_SideMenu", content.SideMenu);
sp[9] = new OleDbParameter("p_user", "john");

OleDbHelper.ExecuteNonQuery(Settings.ConnectionStr ing,
CommandType.StoredProcedure, sql, sp);
content.Id = FormUtils.ConvertInt(sp[0].Value.ToString());

Aug 21 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.