Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2552
  • Last Modified:

DBMS_RANDOM

How do I create this package/package body, DBMS_RANDOM?  What .sql scripts do I need and what sequence do they have to be run in?  Thanks!
0
camposaa
Asked:
camposaa
  • 2
1 Solution
 
tschofiledCommented:
I did a standard install and its already there.
Have you tried at the sql prompt

desc dbms_random

Tony
0
 
tschofiledCommented:
Its installed by the file in $ORACLE_HOME?rdbms/admin/rdbmsrand.sql

Tony
0
 
camposaaAuthor Commented:
This is what I get!

SQL> describe dbms_random
ERROR:
ORA-04043: object dbms_random does not exist
0
 
jim144Commented:
Check your permissions ... if the user trying to use the package does not have the proper permissions on the package, you will always get that error message. To grant permission to the package, run the following as the SYS user .....

GRANT EXECUTE ON SYS.DBMS_RANDOM TO <username>;
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

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