Re: Random Number Generator for use in Oracle?

Matthew Cunningham wrote:
>
> Hi All
>
> I have attempted to load up Oracles cryptographic toolkit to use the random
> number generator that comes with it.
>
> In svrmgrl I exectuted the following.
> connect (as sys user)
> @dbmsoctk.sql
> @prvtoctk.plb
> @dbmsrand.sql
>
> When loading the toolkit I have come across errors when loading
> prvtoctk.plb.
>
> What is a plb file and does anyone have any suggestions as to what I can do
> to fix the error listed below?
>
> Is there an easier way to use a random number generator with Oracle?
>
> Thanks in advance
>
> Matt
>
> MGR-00072: Warning: PACKAGE BODY DBMS_CRYPTO_TOOLKIT created with
> compilation er
> rors.
> SVRMGR> SVRMGR> show errors
> Errors for PACKAGE BODY DBMS_CRYPTO_TOOLKIT:
> LINE/COL ERROR
> ----------------------------------------------------------------------------
> ----
> 327/45 PLS-00201: identifier 'UTL_RAW.CAST_TO_RAW' must be declared
> 324/10 PL/SQL: Statement ignored
> 353/45 PLS-00201: identifier 'UTL_RAW.CAST_TO_RAW' must be declared
> 350/10 PL/SQL: Statement ignored
> 405/8 PLS-00201: identifier 'UTL_RAW.CAST_TO_VARCHAR2' must be declared
> 404/10 PL/SQL: Statement ignored
> 427/8 PLS-00201: identifier 'UTL_RAW.CAST_TO_VARCHAR2' must be declared
> 426/8 PL/SQL: Statement ignored
> 470/27 PLS-00201: identifier 'UTL_RAW.CAST_TO_RAW' must be declared
> 467/10 PL/SQL: Statement ignored
> 483/27 PLS-00201: identifier 'UTL_RAW.CAST_TO_RAW' must be declared
> 480/10 PL/SQL: Statement ignored
> 517/29 PLS-00201: identifier 'UTL_RAW.CAST_TO_RAW' must be declared
> 514/10 PL/SQL: Statement ignored
> 563/29 PLS-00201: identifier 'UTL_RAW.CAST_TO_VARCHAR2' must be declared
> 563/9 PL/SQL: Statement ignored
> 580/16 PLS-00201: identifier 'UTL_RAW.CAST_TO_VARCHAR2' must be declared
> 580/9 PL/SQL: Statement ignored
> 631/30 PLS-00201: identifier 'UTL_RAW.CAST_TO_VARCHAR2' must be declared
> 631/10 PL/SQL: Statement ignored

In the same directory there will be a file to load UTL_RAW (utlraw.sql). Run this in first..

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Early to bed and early to rise, 
 makes a man healthy, wealthy and wise." - some dead guy