Re: asynchronous query

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Tue, 02 Jun 1998 13:54:39 GMT
Message-ID: <357503c8.2882284_at_192.86.155.100>

A copy of this was sent to Jinqlih Sang <csang_at_home.com> (if that email address didn't require changing) On Tue, 02 Jun 1998 07:20:36 GMT, you wrote:

>Does anyonw know if oracle can handle asynchronous query
>in dynamic SQL (Pro C)?

You can sort of background things using dbms_jobs but to do a 'real' async query you need to use non-blocking OCI. Pro*C can't do non blocking calls (you need a more sophisticated API then the EXEC SQL syntax allows for). You can however mix OCI and pro*c together to accomplish this (using pro*c for all but the non-blocking calls)  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA  

http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Tue Jun 02 1998 - 15:54:39 CEST