Password-generator (sys.v_$timer)

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 Received on Mon May 16 2005 - 05:24:42 CDT