Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Random Number Generator for use in Oracle?

Random Number Generator for use in Oracle?

From: Matthew Cunningham <mcunning_at_vcs.org.au>
Date: Tue, 24 Oct 2000 08:46:47 +1000
Message-ID: <9k2J5.3$QP5.1884@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
Received on Mon Oct 23 2000 - 17:46:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US