>> If I run such statement without delay it would consume all CPU.
>>
>>
>
>Could you tell us more specifically what you're trying to do.
>There's a Firebird feature called events that may be exactly
>what you need.
>
>Regards,
>
>
>Ann
>
>
>

There is a service running on FB server machine, which is doing some
synchro job with other DB.
SP runs, writes some formated questions to question table
Sleeps until external service process processes questions (until
there is no anwer in question table)
External process answers the questions, writes them down to table
SP wakes up, reads answers, returns results.

This can be done via UDF, but udf is quite hard to write according to
external process implementation, so I am looking for other solutions.

Adomas