dbms_random.initialize(12345); -- use at least a 5 digit number

create or replace procedure getrandom is
begin
dbms_output.put_line(dbms_random.random);
end;
/


SQL>execute getrandom
-1324234211

Don't reset the seed each time, and the random will work just fine. Procedures/functions include:

initialize, seed, random, terminate

See metalink article 1053864.6