create or replace procedure Select_User
( ID in varchar2,
Pass in varchar2)
as
begin
select USER_ID,USER_PASSWORD,USER_FUNDS
from USERINFO where USER_ID=ID and USER_PASSWORD=Pass;
end;
我写了上面一个存储过程,在sql Plus里面执行时,从说程序有错误,
然后,我用了EXECUTE Select_UserInfo('222','52');
还是报了很多错误,请问我的存储过程的写法正确吗?
( ID in varchar2,
Pass in varchar2)
as
begin
select USER_ID,USER_PASSWORD,USER_FUNDS
from USERINFO where USER_ID=ID and USER_PASSWORD=Pass;
end;
我写了上面一个存储过程,在sql Plus里面执行时,从说程序有错误,
然后,我用了EXECUTE Select_UserInfo('222','52');
还是报了很多错误,请问我的存储过程的写法正确吗?
{
OracleParameter oparm = new OracleParameter("P_CURSOR", OracleType.Cursor);
oparm.Direction = ParameterDirection.Output;
DataSet ds;
ds = OracleHelper.ExecuteDataset(con, CommandType.StoredProcedure, "sys_DepartmentCategoryGetAll",oparm);
con.Close();
return ds.Tables[0];
}
如
create ...
is
i varchar(20);
begin
select a.id into v_id from yourtable a;
end;
建议你还是找本书看看