Re: Problem with DBMS_RANDOM package.Random numbers ?

Either you don't have execute privilege for the dbms_random package or the public synonym dbms_random is missing.

Hth,

--
Sybrand Bakker, Oracle DBA
George D. Benetos <gbene_at_intrasoft.gr> wrote in message news:86minm$7dn$1_at_foo.grnet.gr...
> Hello ,
> This is the problem :
> I;m trying to use the package DBMS_RANDOM to produce random number , but
> there is a mistake.
> The SQL Block is :
> ---------------------------------------------------------------------
> declare
>
> k number;
> i number;
>
> j BINARY_INTEGER;
>
> begin
>
> j:=10000;
> DBMS_RANDOM.INITIALIZE(j);
> DBMS_RANDOM.SEED(10000);
> k:=DBMS_RANDOM.RANDOM;
> DBMS_OUTPUT.PUT_LINE(k);
> DBMS_RANDOM.TERMINATE;
>
> end;
> ------------------------------------------------------------------------
>
> and the message is :
> --------------------------------------------------------------------------
--
> -------------------------
> ORA-06550: line 11, column 1:
> PLS-00201: identifier 'DBMS_RANDOM.INITIALIZE' must be declared
> --------------------------------------------------------------------------
--
> -------------------------
>
> Any ideas ?
>
> Furthermore , is there another way to produce random numbers in Oracle ?
>
> Thanks in advance .....
>
> --------------------------------------------------------------------------
--
> -----------
> George D. Benetos
> Electrical & Computer Engineer , NTUA
>
> --------------------------------------------------------------------------
--
> ---------
> -
>
>
Received on Wed Jan 26 2000 - 06:15:12 CST