ASP中:
string addictno11;
addictno11 = Request.Params[ "id "];
OracleConnection conn = new OracleConnection( "Data Source=duke;Persist Security Info=True;User ID=gxjd;Password=gxjd ");
OracleCommand cmd = new OracleCommand( );
cmd.Connection = conn;
cmd.CommandText = "DUKESELECT2 ";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new OracleParameter( "addictnox ", OracleType.VarChar,20, addictno11));
conn.Open();
cmd.ExecuteNonQuery();
conn.close(); ////////////////////////ORACLE中的存储过程
PROCEDURE DUKESELECT2
(addictnox in varchar2)
AS
CURSOR T1
IS
select photo,nationalitycd.NationalityDesc,sexcd.sexdesc,educd.edudesc,vocationcd.vocationdesc
from addict,sexcd, NationalityCD,educd,vocationcd
where (addict.Nationality =nationalitycd.NationalityID(+)) and (addict.sex =sexcd.sexid(+))
and (addict.education =educd.eduid(+)) and (addict.vocation =vocationcd.vocationid(+))
and addictno = addictnox;
XX T1%rowtype;
BEGIN
open T1;
fetch T1 INTO XX;
CLOSE T1;
END;
在VS中运行会提示:cmd.ExecuteNonQuery()调用存储过程DUKESELECT2时候参数数量或类型出错..
这种错误,我不太会处理....
string addictno11;
addictno11 = Request.Params[ "id "];
OracleConnection conn = new OracleConnection( "Data Source=duke;Persist Security Info=True;User ID=gxjd;Password=gxjd ");
OracleCommand cmd = new OracleCommand( );
cmd.Connection = conn;
cmd.CommandText = "DUKESELECT2 ";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new OracleParameter( "addictnox ", OracleType.VarChar,20, addictno11));
conn.Open();
cmd.ExecuteNonQuery();
conn.close(); ////////////////////////ORACLE中的存储过程
PROCEDURE DUKESELECT2
(addictnox in varchar2)
AS
CURSOR T1
IS
select photo,nationalitycd.NationalityDesc,sexcd.sexdesc,educd.edudesc,vocationcd.vocationdesc
from addict,sexcd, NationalityCD,educd,vocationcd
where (addict.Nationality =nationalitycd.NationalityID(+)) and (addict.sex =sexcd.sexid(+))
and (addict.education =educd.eduid(+)) and (addict.vocation =vocationcd.vocationid(+))
and addictno = addictnox;
XX T1%rowtype;
BEGIN
open T1;
fetch T1 INTO XX;
CLOSE T1;
END;
在VS中运行会提示:cmd.ExecuteNonQuery()调用存储过程DUKESELECT2时候参数数量或类型出错..
这种错误,我不太会处理....
解决方案 »
- c# 如何把图片嵌入到DLL中,并调用这个资源DLL
- 求高手们搭救,编写一个控制台应用台程序,来检验装箱和拆箱!
- asp.net 还原sql 2005数据库,如果被占用怎么办?
- C#typeof(object)的问题。内详
- 如何在txt文件中添加新的数据?
- 如何动态设置特性(Attributes)?
- 有2进制数组,和文件名称。如何创建文件
- C#中如何处理等待任一线程的结束?比如C++中的WSAWaitForMultipleEvents函数
- webform:刷新页面时,怎么阻止password格式的内容被清空啊?
- C# 类的转换
- 关于重画窗口标题栏及四周围边框,急!
- 如何在2005中使用autoupdater实现程序自动更新?
oledbparameters怎么写,改哪哦...