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

<benster_at_tjockhult.se> a écrit dans le message de news:1116239082.525670.260370_at_o13g2000cwo.googlegroups.com...
| 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
|

roles are not enabled in PL/SQL.

Regards
Michel Cadot Received on Mon May 16 2005 - 06:04:32 CDT