Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to check if a Function exists in a package
In article <1169803166.823292.78470_at_s48g2000cws.googlegroups.com>,
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.
-- jeremy (no sig is better than a pointless sig)Received on Fri Jan 26 2007 - 05:00:05 CST
![]() |
![]() |