Yield to Other application from PL/SQL

From: Atul Kane <akkane_at_worldnet.att.net>
Date: 1998/05/07
Message-ID: <6itrf2$9u6@bgtnsc01.worldnet.att.net>#1/1

Hi there !
I'm calling a stored procedure from within powerbuilder. the stored procedure is very complex & does lot of things. It creates a log file of what it does.
I'm displaying the contents of this file on the powerbuilder window, so the user knows what is going on.

Now my problem is how to code in PL/SQL to give up resources for a split second (yield)
so that my Powerbuilder application can read the log file & display it as it being written by procedure.

I tried coding in the timer event of PB window but it doesn't work. (timer event is very low priority of Windows OS) The file is displayed only after the procedure
is completely executed.

i'm using windows95, Oracle 7.3 , PB 5

Any help would be appreciated

-Atul Received on Thu May 07 1998 - 00:00:00 CDT