create or replace procedure  putanalyse(
id_pacient in int,id_medic in int)

AS
message varchar(1000);
id_analiza number;
v1 float;v2 float;v3 float;v4 float;v5 float;v6 float;v7 float;v8 float;v9 float;
BEGIN

select id_analiza into id_analiza from (select * from analize order by id_analiza desc) where rownum<2;
id_analiza:=id_analiza+1;
v1:=rand(0,3); v2:=rand(7,12); v3:=rand(120,170); v4:=rand(0,270); v5:=rand(25,175); v6:=rand(25,140); v7:=rand(150000,450000); v8:=rand(4500,11000); v9:=rand(100,300);

INSERT INTO
ANALIZE (
 "ID_ANALIZA",
    "ID_PACIENT",
    "ID_MEDIC",
    "DATA_EFECTUARII",
    "MAGNEZIU",
    "CALCIU",
    "SODIU",
    "COLESTEROL",
    "TRIGLICERIDELE",
    "GLICEMIA",
    "TROMBOCITE",
    "LEUCOCITE",
    "HEMATII"
    )
VALUES (id_analiza,id_pacient,id_medic,to_date('1985-04-16','YYYY-MM-DD'),v1,v2,v3,v4,v5,v6,v7,v8,v9);
message:='totul a decurs ok';
END putanalyse;
 /
call putanalyse(4,4);