Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to check if a Function exists in a package

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

From: Jeremy <jeremy0505_at_gmail.com>
Date: Fri, 26 Jan 2007 11:00:05 -0000
Message-ID: <MPG.2023ef907824f5ca98a3d5@news.individual.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US