对,要用select svalue into sValue from table2 where id = nid 才行!
那么修改以后 运行 OracleDataReader r = pCommands_.SelectCommand.ExecuteReader();时出现错误
你首先要检查你的存储过程是否有错误,然后检查使用权限、调用参数、对象捆绑等; 出现了错误后,要根据错误信息进行判断以及跟踪信息。CREATE OR REPLACE PROCEDURE PROC_1 ( nid in number, sValue out number ) as begin select col_value into svalue from table2 where id = nid; end proc_1;
CREATE OR REPLACE PROCEDURE PROC_1 ( nid out number, sValue out number ) as ... insert into table1(id, tvalue) values (100, "100"); select id into nid tvalue into svalue from table2 where id = id; 就是前面多了一个insert 语句,insert语句会影像吗?
才行!
出现了错误后,要根据错误信息进行判断以及跟踪信息。CREATE OR REPLACE PROCEDURE PROC_1
(
nid in number,
sValue out number
)
as
begin
select col_value into svalue from table2 where id = nid;
end proc_1;
(
nid out number,
sValue out number
)
as
...
insert into table1(id, tvalue) values (100, "100");
select id into nid tvalue into svalue from table2 where id = id;
就是前面多了一个insert 语句,insert语句会影像吗?