dbms_random

spathiyal@yahoo.ca · *nix forums beginner Joined: 20 Jul 2005 Posts: 7

I have a question regarding dbms_random pkg.
One jsp page needs to pull a random password from a table.

So, first I created a table and inserted 100 passwords and used this
sql to display the random password.
SELECT password FROM
( SELECT password from px_password_selfreg ORDER BY
DBMS_RANDOM.RANDOM )
WHERE ROWNUM = 1;

Is this enough or do I need to initialize and terminate the pkg before
and after the use?

Thank you in advance,

sheen

Michel Cadot · *nix forums Guru Joined: 24 Apr 2005 Posts: 457

"Sheela" <spathiyal@yahoo.ca> a écrit dans le message de
news:678ae5f9.0502040759.748b3178@posting.google.com...
| I have a question regarding dbms_random pkg.
| One jsp page needs to pull a random password from a table.
|
|
| So, first I created a table and inserted 100 passwords and used this
| sql to display the random password.
| SELECT password FROM
| ( SELECT password from px_password_selfreg ORDER BY
| DBMS_RANDOM.RANDOM )
| WHERE ROWNUM = 1;
|
| Is this enough or do I need to initialize and terminate the pkg before
| and after the use?
|
|
| Thank you in advance,
|
| sheen

From doc (Supplied PL/SQL Packages and Types Reference):
<quote>
Requirements
DBMS_RANDOM must be initialized before calling the random number generator. The generator produces
8-digit integers. If the initialization subprogram is not called, then the package raises an
exception.
</quote>

But if you look inside package specification, you'll see:
<quote>
-- By default, the package is initialized with the current user
-- name, current time down to the second, and the current session.
</quote>

....

Regards
Michel Cadot

Google