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: Package functions and procedures

Re: Package functions and procedures

From: <frank.van.bortel_at_gmail.com>
Date: 23 Jan 2007 03:42:46 -0800
Message-ID: <1169552565.959049.238610@a75g2000cwd.googlegroups.com> 






schw schreef:


> Hi

>

> is there any way to check whether particular function or procedure

> exists in a package?

>

> thanks

> schw




Whenever declared in the package specification, you can:
SQL> desc [package_name]



If it is not listed, it may be private - it will be of no use to you,
as you cannot call it; you can only call packaged functions
or procedures when these are declared in the package specification.
Received on Tue Jan 23 2007 - 05:42:46 CST












Original text of this message













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