The following error message is recieved in the resin.stderr
java.sql.SQLException: ORA-01426: numeric overflow
ORA-06512: at "SYS.DBMS_RANDOM", line 188
when following The following query is executes
select user_id from ( select
dbms_random.random, user_id from users where locale = 'es_usa and nickname is NOT NULL and sex_id = 2
and rownum <= 5000 order by 1 )
what is this and why is this happening ?