• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 905
  • Last Modified:

Error in dbms_random.random

hi experts,

  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 ?
regards,
0
umar1farooq
Asked:
umar1farooq
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
please try this:

  select user_id from ( select
  dbms_random.value(1,10000), user_id from users where locale = 'es_usa and nickname is NOT NULL  and sex_id = 2
  and rownum <= 5000 order by 1 )
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now