Subject Re: [firebird-support] intermediate messages from a query
Author Helen Borrie
At 09:25 PM 11/09/2003 +0000, you wrote:
>please look this code:
>create procedure test
> (cmessage varchar(20)
> for select id_emp from tb_emp do
> begin
> cmessagge='employee ' || id_per || ' is being processed';
> suspend;
> /*some action*/
> end
>only _at the end_ of the query I get the messages _all together_,
>what is completely unuseless to me.
>No way to get what I want ?

Not this way. A stored procedure call is atomic. It can't interact with
the client during execution. What your procedure actually does is build an
output set. If the procedure completes without an exception, you get the
output set. If an exception occurs at any point, the procedure will exit
and return the exception -- and there will be no output.