Re: Password-generator (sys.v_$timer)

benster_at_tjockhult.se wrote:
>
> Hi!
>
> I am currently developing a password-generating-function in Oracle.
>
> I am trying to use the SQL:
> "SELECT lower(chr(substr(TO_CHAR(hsecs) / 8640000,22,3))) FROM
> SYS.v_$timer;"
>
> This works OK when I run the SQL in Toad, but when I try to put the
> result in a variable and use the SQL in my function the function
> doesn't get properly compiled...
> ("SELECT lower(chr(substr(TO_CHAR(hsecs) / 8640000,22,3))) INTO SLUMPEN
> FROM SYS.v_$timer;")
>
> When I try to recompile the function it says "Identifier 'SYS.V_$TIMER'
> must be declared.
>
> Hmm..ideas on how to solve this one?
>
> Best regards
>
> /Ben

How about

dbms_random.value

or dbms_utility.get_hash_value

hth
connor

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------