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

Home -> Community -> Usenet -> c.d.o.misc -> PL/SQL Function Name Declaration

PL/SQL Function Name Declaration

From: kong <kongkong99_at_yahoo.com>
Date: 19 May 2004 02:27:08 -0700
Message-ID: <cc50806d.0405190127.3c7e4dae@posting.google.com> 





Hi,



I have created a function and coded it within a Package. At first, I
declared this function name at package body. It prompted error when i
tried to use this function in a sql (within that package).  The error
is "This function may not be used in sql".



However, it is working fine when i declare the function at package
specification. May I know why such occurrence happened? Any solutions
for this as I do not want to declare it at package specification.



Thanks in advance.
Received on Wed May 19 2004 - 04:27:08 CDT












Original text of this message













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