Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Random Number Generator for use in Oracle?
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 ignoredReceived on Mon Oct 23 2000 - 17:46:47 CDT
![]() |
![]() |