At 10:07 PM 14/02/2008, you wrote:

>Can I write Firebird functions in PL/SQL? For all I know it's not possible
>and I must use UDF, but maybe I am mistaken (I wish I were - I need to write
>a function and UDF is something I need to avoid if at all possible).
>Unfortunatelly I can't find any relevant information on this in the
>documentation.

No, you can't....but...

>I would appreciate any pointers.

You can write SPs that return a single value to the caller - which may be a client application, a trigger or another SP. You can't invoke them like functions but your requirement might enable you to define a reusable procedure call that will achieve the same end.

Why not describe what you want to do and see what suggestions come up.

./heLen