Procedura v pl/sql

create or replace procedure "PACIENT_CLONE"
(rc IN OUT  pacient.rodne_cislo%TYPE, prijmeni OUT pacient.prijmeni%TYPE,
jmeno OUT pacient.jmeno%TYPE, pohlavie OUT pacient.pohlavie%TYPE)
is
begin
SELECT prijmeni INTO prijmeni FROM pacient WHERE rodne_cislo = rc;
SELECT jmeno INTO jmeno FROM pacient WHERE rodne_cislo = rc;
SELECT pohlavie INTO pohlavie FROM pacient WHERE rodne_cislo = rc;
INSERT INTO pacient_zaloha VALUES (rc,prijmeni,jmeno,pohlavie);
DELETE FROM pacient WHERE rodne_cislo=rc;
end pacient_clone;​

create or replace procedure "PACIENT_CLONE" (rc IN  pacient.rodne_cislo%TYPE) as
prijmeni pacient.prijmeni%TYPE;
jmeno pacient.jmeno%TYPE;
pohlavie pacient.pohlavie%TYPE;
begin ...

SELECT prijmeni, jmeno, pohlavie INTO prijmeni, jmeno, pohlavie FROM pacient WHERE rodne_cislo = rc;