Re: Random Number Generator for use in Oracle?

Followng utlraw.sql and prvtrawb.plb, I think the next ones to execute are

    utlpg.sql
and

    prvtpgb.plb

--

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

Matthew Cunningham wrote in message ...


>Hi Connor

>

>Thankyou so much for your help.  I managed to compile the procedures etc

>after running utlraw.sql

>

>However on attempting to initialise the random number I receive the

>following error message:

>

>execute dbms_random.initialize(123123);

>begin dbms_random.initialize(123123); end;

>

>*

>ERROR at line 1:

>ORA-04068: existing state of packages has been discarded

>ORA-04067: not executed, package body "SYS.UTL_RAW" does not exist

>ORA-06508: PL/SQL: could not find program unit being called

>ORA-06512: at "SYS.DBMS_CRYPTO_TOOLKIT", line 1136

>ORA-06512: at "SYS.DBMS_RANDOM", line 20

>ORA-06512: at line 1

>

>I can desc the packages.  They all compiled with no errors.  I have tried

>running it from my local login and also from the SYS login but with the

 same


>error.  I can desc UTL_RAW so I know it exists.

>

>Any more very helpful suggestions?

>

>Thanks Again

>Matt

>

>"Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message

>news:39F56D4C.4964_at_yahoo.com...

>> 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

>

>