There might be several reasons why you can't use the package DBMS_RANDOM. Check in the following order:

1. Is package and package body SYS.DBMS_RANDOM installed in your system? AFAIK this package is not instaled by default.

2. If it is installed, is it valid? It might be that some packages on which it depends are not installed or valid (like DBMS_CRYPTO_TOOLKIT).

3. If both 1. and 2. are OK, check your synonyms and privileges on that package.


If the package DBMS_RANDOM is not installed, you have to instal it under schema SYS. You have to run scrypt $ORA_HOME/rdbms/admin/dbmsrand.sql

You might also need to install DBMS_CRYPTO_TOOLKIT (scrypts dbmsoctk.sql and prvtoctk.plb), UTL_RAW (utlraw.sql and prvtrawb.plb) and mybe some others to succesfully compile DBMS_RANDOM.