create or replace procedure get_username
  as
  begin
v_id in number:=1
select * from uc_t_staff t where t.id = v_id
  end get_username;

05-27 06:41