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