Need to hash password on form to match oracle password
I have an Apex application which uses database authentication.
I am pretty much using the standard login Screen and am passing the username and password in the URL.
I am using an exists query to check that the username is valid and everything is working fine.
The oracle password is stored hashed in the dba_users table. What I want to do is use the dbms_utility.get_hash_value function to generate the same hash value that oracle generates.
So if my password for system is the default of manager, then I would use the following to get the hash value for manager
select dbms_utility.get_hash_value( 'MANAGER', X, Y)
What I need to know is what value of X and Y does oracle use
X is the base number and y is the hash size