Re: stored funtion in cursor
Date: Wed, 11 Aug 1999 23:34:39 -0400
Message-ID: <7otg6l$188_at_dfw-ixnews10.ix.netcom.com>
Generally speaking, any function you can use in PL/SQL can be used in Forms.
Check the SQL in PL/SQL first. If the function is part of a package, make
sure you use the PRAGMA RESTRICT_REFERENCES directive to specify the
function's purity level. i.e.
package xyz
function abc(...) return number;
pragma restrict_references(abc,wnds,wnps)
end xyz;
Then you can:
select * from mytab where somecolumn = xyz.abc(someparm);
River wrote in message <37AEE84D.D4A0D46D_at_vol.net>...
>In Forms4.5, is it possible to have a stored function in the where
>clause of a cursor?
>
>Because I hit a error when compiling the code:
>Function ABC may not be used (something like that)
>
>Thank for any advice,
>River
>wychan_at_vol.net
Received on Thu Aug 12 1999 - 05:34:39 CEST