Re: Yield to Other application from PL/SQL

[posted & mailed]

Hi,
If you are lucky (never tried it) you can use the dbms_lock.sleep (or was it dbms_lock.wait) function to 'pause' your pl/sql. I am not sure if dbms_lock implements a 'busy wait' (blocking your entire proces) or not.

Alternatively:
I am not familiar with pb, but if it supports multi-threading you could run your pl/sql in
a separate thread. If it doesn't you could also spawn a separate proces that runs the pl/sql and let the o/s worry about timeslices for your apps.  

-- 
reply address is altered to keep the spam down
remove the nospamplease part to reply...
Gert Rijs
gem at wirehub.nl
www.wirehub.nl/~gem


Atul Kane <akkane_at_worldnet.att.net> wrote in article
<6itrf2$9u6_at_bgtnsc01.worldnet.att.net>...


> 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

> 

> 

> 

> 

> 

>