create or replace procedure sp1 (newheight number, newsid varchar2)asbegin update student set height=newheight where sid=newsid;end sp1;
set serveroutput on;begin sp1(1.77,'000001');end;
select * from student