存储过程中的输入跟输出

存储过程中的输入和输出

存储过程中的输入和输出

create or replace procedure sp_test ascursor c_groupisselect ename from emptestwhere sal > 2000 group by job;beginfor r_group in c_grouploopupdate emptest set comm = comm+3000;end loop;end;create or replace procedure sp_findname (i_ename in varchar2,o_sal out number)asbeginselect sal into o_sal from emptestwhere ename = i_ename;exceptionwhen othersthen dbms_output.put_line('error');end;declarev_sal emptest.sal%type;beginsp_findname('STAR',v_sal);dbms_output.put_line('v_sal is'||v_sal);end;