470,563 Members | 2,339 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,563 developers. It's quick & easy.

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

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

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];
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",
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",
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
0 1495

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by NicK chlam via DotNetMonster.com | last post: by
1 post views Thread by thangchan | last post: by
4 posts views Thread by BookerW | last post: by
1 post views Thread by =?Utf-8?B?Ym9va2VyQG1ndA==?= | last post: by
1 post views Thread by livre | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.