Hello,
I have a very long running stored proc (import and transformation of 2-3 M. records). The duration of about 1h is not the problem.
My problem is that i want to send some notifications to my Application for showing a progress counter in the UI of my Application.
Is there any possibility to send send out a msg after certain steps (e.g. after positioning the cursor to next row) via an extended stored procedure which I could catch in my UI? I don´t think that this is possible with a simple print statement, because that´s not a return parma oder return statement.
I would be very appreciative if somebody would send me a hint.
Thank you,
selo
I have a very long running stored proc (import and transformation of 2-3 M. records). The duration of about 1h is not the problem.
My problem is that i want to send some notifications to my Application for showing a progress counter in the UI of my Application.
Is there any possibility to send send out a msg after certain steps (e.g. after positioning the cursor to next row) via an extended stored procedure which I could catch in my UI? I don´t think that this is possible with a simple print statement, because that´s not a return parma oder return statement.
I would be very appreciative if somebody would send me a hint.
Thank you,
selo