create or replace package testy is
function pw(id_stud studenci.id_student%type) return varchar;
procedure p2(id_stud IN studenci.id_student%type);
end testy;
/                                       <-------------------
create or replace package body testy is

function pw(id_stud studenci.id_student%type)
return varchar
is
begin
UPDATE studenci
set imie=upper(imie),nazwisko=upper(nazwisko)
where id_student=id_stud;
return 'dane zmodyfikowane';
end pw;

procedure p2(id_stud studenci.id_student%type)
is
begin
UPDATE studenci
set imie=upper(imie),nazwisko=upper(nazwisko)
where id_student=id_stud;
end p2;
end testy;
/                                    <------------------------