ORA-00904: Invalid identifier when using dbms_random.value

Question

This article here suggests using dbms_random.value to select random values from a table.

My query

select value1, value2 from 
(select value1, value2 from my.table order by dbms_random.value) 
where rownum <100;

Gives me

Error at Command Line:2 Column://column after the 'by'). 
Error report:
SQL Error: ORA-00904: : invalid identifier
00904. 00000 -  "%s: invalid identifier"

Any suggestions?

dwjohnston · Accepted Answer · 2013-03-24 21:29:26Z

8

Insufficient user priviledges. Don't have access to the dbms_random package.

answered Mar 24, 2013 at 21:29

dwjohnston

12.5k39 gold badges119 silver badges220 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

TrojanName · Accepted Answer · 2019-06-21 09:45:03Z

3

You need to GRANT EXECUTE to your schema. Login as your SYS user and run the following, replacing 'your-schema-name' with the Oracle user who you wish to allow run DBMS_RANDOM.

GRANT EXECUTE ON DBMS_RANDOM TO your-schema-name;

answered Jun 21, 2019 at 9:45

TrojanName

5,4456 gold badges37 silver badges49 bronze badges

Collectives™ on Stack Overflow

ORA-00904: Invalid identifier when using dbms_random.value

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related