SQL & PL/SQL

hi,

i saw on asktom.oracle.com an example in which a procedure was compiled and run successfuilly.. then Tom ran the following query to get no. of total calls by the procedure:

select userenv('client_info') from dual;

when i ran a procedure whcih outputs refcursor and ran the above query to get calls made by my proc.. it does not return any rows.. what I am missing?

I have oracle 9iR2...

Also, userenv('client_info') is deprecated in favour of SYS_CONTEXT..? can u give me example to achieve the same thing i tried above using SYS_CONTEXT?

thx