Re: ASYNC access to ORACLE

In article <3cseun$4ho_at_uplherc.upl.com> dany brown <danny.brown_at_upl.com> writes:
>sb63_at_konichiwa.cc.columbia.edu (Semyon Basin) wrote:
 

>> Hi, Netters!
>> Does anyone know if asynchronous access is possible when you access ORACLE 7?
>> I'd like to submit a query and i do not want to wait until results are
>> generated. Instead i'd like to be notified in some way so i could connect
>> to a database again and get my results.
>> Thanx in advance to all who reply.
>> P.S. We have SQL*NET V2 and ORACLE 7.0.16 running on Dec Ultrix.
>> I'll gladly give more info if needed.
 

>You can set spool in the beginning of the sql script and spool off at
>the end of the sql script.
 

>Then type nohup sqlplus -silent start xxx user/pass &

A more effective technique for programs that must access and update the database might be Oracle In Motion. OIM works over dial up and LAN connections as well as wireless networks.

I speak for myself, not my company.
Mike Friedman Received on Fri Dec 16 1994 - 20:19:38 CET