Re: Random Number Generator for use in Oracle?

From: <pvinnakota_at_my-deja.com>
Date: Mon, 30 Oct 2000 21:05:34 GMT
Message-ID: <8tknqm$73u$1@nnrp1.deja.com>

Hi,
I may be digressing, but when I needed random numbers, we searched the web, and found the requisite routines, which when compiled worked fine(and are still working fine). They are simple, yet effective. Bye,
In article <972411006.27242.1.nnrp-08.9e984b29_at_news.demon.co.uk>,   "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
>
> 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
> >
> >
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Oct 30 2000 - 15:05:34 CST