Re: Random Number Generator for use in Oracle?

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
Received on Tue Oct 24 2000 - 21:12:25 CDT