In V$librarycache , a column called namespace .
I forgot which value is indicate the function or procedure .

Please check it out