Problem with DBMS_RANDOM package.Random numbers ?

From: George D. Benetos <gbene_at_intrasoft.gr>
Date: Wed, 26 Jan 2000 12:38:39 +0200
Message-ID: <86misl$7e8$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 - 11:38:39 CET