Re: User-defined function question

"Noah Arc" <bowed_zombie_drone.spam.begone_at_zombie.co.uk> wrote in message news:Fkdv7.34167$uM2.5065331_at_monolith.news.easynet.net...
> I have a package, in which I've defined some functions.
>
> I'm trying to use one of these functions in a cursor within
> one of the package's procedures, but keep getting error
> messages when I try & create the package:
>
> "PLS-00320: the declaration of the type of this expression is
> incomplete or malformed"
>
> and
>
> "PLS-00231: function <func name> may not be used in SQL"
>
> The cursor statement in the procedure is thus:
>
> CURSOR ccursor_name
> (parameter IN VARCHAR2)
> IS
> SELECT 'x'
> FROM table
> WHERE function(column) = function(parameter);
>
> Thanks for any assistance. My guess is that you can't use
> user-defined functions in cursor declarations, but I'd be
> grateful of any clarification.
> --
> Noah Arc
> Remove ".spam.begone"
>
>

This is not true. So without the code of your function no conclusive answer can be provided.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Fri Oct 05 2001 - 12:24:16 CDT