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: hitman <dsagner_at_post.t-com.hr>
Date: 26 Jan 2007 01:19:26 -0800
Message-ID: <1169803166.823292.78470@s48g2000cws.googlegroups.com> 





>                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.
Received on Fri Jan 26 2007 - 03:19:26 CST












Original text of this message













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