Urgent : How do I show Status of Progress Bar when executing Stored procedure from the VB.

I have developed an application In VB5.0 Enterprise Version And Backend used is Oracle 7.3

Now when I execute a Stored procedure(which takes lots of time) from the VB 5.0 there is no indication another then Mousepointer which tells me whether something is going on or not(at the VB side). Though I have set my cursor to animated/Hourglass to make user feel that something is going on. But is there any other way by which I can show the status on progressbar. I know when vb execute the stored procedures then it keeps quite(I mean thus nothing till the control come back from the RDO calls).

Is there somesort of code or any third party control which will take care of such requirments.

Can someone please help me in solving this problem.