Hi Helen, all,

> >please look this code:
> >
> >create procedure test
> >returns
> > (cmessage varchar(20)
> >as
> >begin
> > for select id_emp from tb_emp do
> > begin
> > cmessagge='employee ' || id_per || ' is being processed';
> > suspend;
> > /*some action*/
> > end
> >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.

Shouldn't this procedure start returning before the complete procedure
is finished because of the SUSPEND?


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com