oracle 存储过程学习一

SQL> set serveroutput on ;
SQL> create or replace procedure month_mobileId(a  in varchar2)
  2  is
  3  v_mobileId number ;
  4  begin
  5  select mobileId into v_mobileId from tmonthfees201010 where rpid=a ;
  6  dbms_output.putline('v_mobileid='||v_mobileId) ;
  7  dbms.output.putline('完成存储过程') ;
  8  end ;
  9  /
 
Warning: Procedure created with compilation errors