Re: stored funtion in cursor

From: Enter your name here <>
Date: Wed, 11 Aug 1999 23:34:39 -0400
Message-ID: <7otg6l$>

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 =;

River wrote in message <>...
>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,
Received on Thu Aug 12 1999 - 05:34:39 CEST

Original text of this message