Re: Random Number Generator for use in Oracle?

This looks as if you need to run the utlraw.sql script first, and possibly its plb file as well, but I can recall what that would be called.

plb is the file type that Oracle Corp uses for pl/sql scripts to generate package bodies (usually) that have been 'wrapped'.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Matthew Cunningham wrote in message
<9k2J5.3$QP5.1884_at_vic.nntp.telstra.net>...


>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

>

>