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

Home -> Community -> Usenet -> c.d.o.server -> Re: dbms_random install error 8.04 NT

Re: dbms_random install error 8.04 NT

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Wed, 08 Sep 1999 13:08:32 -0400
Message-ID: <iJfWN5TXKTUc3864q5YXDHAE7iAN@4ax.com>


A copy of this was sent to wchin2a_at_my-deja.com (if that email address didn't require changing) On Wed, 08 Sep 1999 07:43:18 GMT, you wrote:

>I was trying to follow the instructions given in
>http://x28.deja.com/getdoc.xp?
>AN=502555151&CONTEXT=936775957.646316038&hitnum=15
>
>I log on as sys, and run the 3 scripts in order:
>dbmsoctkl.sql, prvtoctk.plb and dbmsrand.sql
>
>I get the following error on the last SQL
>statement in prvtoctk.plb
>

you need to install utl_raw as well -- many times it is installed (replication and procedural gateways will install it for example).

cd $ORACLE_HOME/rdbms/admin
ls *raw*

that'll find a spec and a body. install the spec "@utlraw" first then the body "@prvtraw.plb" using SVRMGRL when connected as INTERNAL or SYS.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Sep 08 1999 - 12:08:32 CDT

Original text of this message

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