下面这两条oracle的存储过程不行 无效，帮忙看看吧：配置报错 

下面这两条oracle的存储过程不行 无效，帮忙看看吧-

-有返回值的存储过程（非结果集） create or replace procedure sp_select_table (param1 in varchar2,param2 out varchar2) as    

   --begin select into param2 from MyTable where ID = param1 ;  

  begin select into param2 from testu where AP_ID = param1 ;  

end sp_select_table ;

create or replace procedure sp_selected (param1 in varchar2,param2 out varchar2) as    

 begin select into param2 from testu where AP_ID = param1 ;  

end sp_selected ;