Subject Re: return status from SP
Author Milan Babuskov
--- In, "Martijn Tonies"
<m.tonies@...> wrote:
> > I have a long running stored procedure which does
> > alot of things. I need to be able to report the status
> > of operation to client at certain points...Just a simple string
> > message would do...
> >
> > Any ideas how to implement this?
> There's actually only 1 way to do this.
> Create a select-able stored procedure:

2. Use external table

But selectedable SP *is* the right way if you want to monitor from
same connection that started the procedure.