If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Your DBMS_RANDOM package is obviously not the package that Oracle supplies in its distribution from 8.0 onward. Yours must be one of those home made PL/SQL random generators that were available on the internet for releases 7.*. Obviously you have named this home made package with the same name oracle names its built-in random generator: DBMS_RANDOM (although I would strongly discourage the usage of the built-in names for user generated objects).

Why the DBMS_RANDOM from your code could not be original SYS.DBMS_RANDOM package?

1.) There is no function DBMS_RANDOM.VALUE in original package

2.) DBMS_RANDOM.SEED procedure accepts only BYNARY_INTEGER parameter, while you parameter is string with nonnumerical characters

3.) You must first initialize the package (supply an initial seed value) with DBMS_RANDOM.SEED procedure before you start using it

Jurij ModicASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?