Re: Oracle Built-in Packages - DBMS_RANDOM

David wrote:
>
> H E L P
>
> Q1: How do you either install or enable DBMS_RANDOM ???
>
> DBMS_RANDOM did not install by default after our Typical 8.1.5 Server
> install.
>
> Expected DBMS_RANDOM to be loaded by catproc.sql.
>
> The other Oracle Built-in Packages DBMS_SESSION, DBMS_ALERT,
> DBMS_PIPE, and DBMS_JOB are loaded and operational.
>
> For your information DBMS_RANDOM is a random number generator package,
> new to 8x. The package must exist and be loaded prior to the
> installation of a paticular 3rd party package.
>
> select * from user_objects where object_name = 'DBMS_RANDOM' ;
>
> ================
> 0 rows
>
> Thank you, in advance !!!
>
> Regards,
> David
>
> PS: We are not writing Oracle packages, we just want to install one.
> Therefore, we will hold off on purchasing the O'REILLY book until we
> get really, really desperate.

http://govt.oracle.com/~tkyte/Misc/Random.html

Cheers
Connor

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse