Re: How to check if a Function exists in a package

From: Stefan Wetter <swetter_at_arcor.de>
Date: Fri, 26 Jan 2007 15:13:53 +0100
Message-ID: <45ba0c41$0$30317$9b4e6d93@newsspool1.arcor-online.net>

Jeremy schrieb:
> hitman says...

>>>                if existfunction(p_customer.a) then
>>> Is that possible to have a function existfunction() to do it like
>>> described above?
>>>
>>
>> Shouldn't be a problem. Check table USER_SOURCE, columns: "name" and
>> "type" and return true if your function exists.
>>
>>

>
> Surely will lead to a compile time error if the function is referenced
> but doesn't exist.
>

I think that would not be a problem if i change the call from direct to dbms.execute, what do you think? Received on Fri Jan 26 2007 - 08:13:53 CST