Referencing a function residing in another schema

[mozgheib]

Hello,

I have a function by the name isnum. I need to
reference it from another schema here is the
syntax

select *
from y
where isnum(x) = 0

I am getting an invalid column name when running it.
I prefixed the schema name to the function name no
same problem. If I run my query under the same schema
where the function is it works just fine.

Any ideas.

Thanks

 

[BJCooperIT]

Has the schema that owns the function granted the 2nd schema "execute privileges" on the function?

[sup]Beware of false knowledge; it is more dangerous than ignorance.[/sup][sup] ~George Bernard Shaw[/sup]
Systems Project Administrator/Custom Forms & PL/SQL - Oracle/Windows

 

[mozgheib]

You are absolutely right. The error message
I was getting was not significant. I have granted
the necessary rights and now it works.

THanks.