Re: Function to retrieve oracle roles

In addition to the other answers you got, please note:

Adam C wrote:
> Hello guru's
>
> I am trying to write a function that will retrieve the current users
> roles. From the PL/SQL prompt I can "Select * FROM SESSION_ROLES;" and it

There is no PL/SQL prompt. You are perhaps speaking of the SQL/PLUS prompt?

Enjoy.

-- 
Ed Prochak
running    http://www.faqs.org/faqs/running-faq/
netiquette http://www.psg.com/emily.html
--
"Two roads diverged in a wood and I
I took the one less travelled by
and that has made all the difference."
robert frost