程序中代码:
public static OracleDataReader RunProcGetReader(string procName)
{
OracleConnection conn = ReturnConnection(); OracleCommand cmd = new OracleCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = conn; cmd.CommandText = procName; if (prams != null)
{
foreach ( OracleParameter parameter in prams)
{
if(parameter != null)
{
cmd.Parameters.Add(parameter);
}
}
}
OracleDataReader odr = cmd.ExecuteReader(CommandBehavior.CloseConnection); return odr;
}
数据库中的存储过程:(这样写有错误,不知道正确的怎么写)
create or replace procedure GetAllUsers
as
begin
select * from users;
end GetAllUsers;sqlserver中这样就可以直接得到结果集了,oracle中该怎么得到结果啊?
public static OracleDataReader RunProcGetReader(string procName)
{
OracleConnection conn = ReturnConnection(); OracleCommand cmd = new OracleCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = conn; cmd.CommandText = procName; if (prams != null)
{
foreach ( OracleParameter parameter in prams)
{
if(parameter != null)
{
cmd.Parameters.Add(parameter);
}
}
}
OracleDataReader odr = cmd.ExecuteReader(CommandBehavior.CloseConnection); return odr;
}
数据库中的存储过程:(这样写有错误,不知道正确的怎么写)
create or replace procedure GetAllUsers
as
begin
select * from users;
end GetAllUsers;sqlserver中这样就可以直接得到结果集了,oracle中该怎么得到结果啊?
连不上数据库,我也没法进行了