Use of SYS views (V$...) in trigger

Hallo all!

how can I use V$-views in trigger other user? I get always an error:  PLS-00201 more identifier ' SYS.V_$... ' must declared. I already tried to hide it in a function my_function which I create as SYS and then:
create public synonym .... In this case ORACLE says:  PLS-00201 more identifier ' SYS.my_function ' must declared (although already public synonym exists!).

 Does someone have a Idea?

Thank you in advance Received on Thu Feb 28 2002 - 08:08:48 CST