I've created and compiled a new SQL function. I CAN'T see it under the functions branch in the Navigator tree . I've tried "refresh" - it's definitely not there.
When I try to RE-create it , the message appears that it already exists - even though I can't see it.
I can't run it, I can't edit it , but if definitley exists. Even though it's invisible
All very Zen, but where do I find it ?
Post the full version number of sql developer that you are using.
What user created the function?
What user OWNS the function?
Are you looking in the nav tree branch of the user that OWNS the function?