At 05:49 PM 3/14/2002 +0100, =?iso-8859-2?Q?Ale=B9_Kah=E1nek?= wrote:

>is possible to call SQL query within UDF?

It is possible, but neither recommended nor easy. The UDF does
not inherit the client context - connection and transaction. So
to execute SQL from a UDF you must first connect, then open a
transaction. Changes made by the UDF will not be visible to the
client, and can cause deadlocks.


Regards,

Ann
www.ibphoenix.com
We have answers.