The call looks like this:
DBMS_SESSION.IS_ROLE_ENABLED (A few times in the pass I've had need to check the role of the logged in user. I would do that with something like this:
CREATE OR REPLACEI did something similar here (and I can't believe no one told me about this function!).
FUNCTION role_enabled( p_role_name IN VARCHAR2 ) RETURN BOOLEAN
WHERE grantee = USER
AND role = p_role_name;
WHEN no_data_found THEN
Lesson? Before building something on your own (even something this simple), search through the documentation to see if Oracle has already done it.
Update This was shown to me by my colleage, @serge_a_storms