是的啊,怎么参数名与字段名相同名字呢,那会认为全成立,把所有选出来.
procedure get_data(p_first_name in students.First_Name%type,cur out rc_test) is
begin
open cur for 'select * from students where First_Name='||p_first_name;
end get_data;
procedure get_data(p_first_name in students.First_Name%type,cur out rc_test) is
begin
open cur for 'select * from students where First_Name='||p_first_name;
end get_data;
谢了!