Subject Re: [firebird-support] return status from SP
Author Martijn Tonies

> 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:

create procedure ...

It should return a parameter "Status: varchar(..." or whatever
you want to use. eg, if it's 5 step parameter, you could also
return a smallint.

After each step, use SUSPEND.

Now, call the procedure:

select * from my_selectable_procedre;

while not query.eof
do begin

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
My thoughts:
Database development questions? Check the forum!