THe second option may be difficult to implement at this stage.

Did not catch the first one though , even if i manage to update a progress table, i will be able to query and send the result back to my front end only when the call to the procedure is over. which may not serve my purpouse.

is there a way with thresds or some thing this can be implemented??