Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> PL/SQL Function Name Declaration
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
![]() |
![]() |