Re: ASYNC access to ORACLE
Date: Fri, 16 Dec 1994 15:42:16
Message-ID: <asingh.5.00784364_at_us.oracle.com>
In article <3csp8a$1q7_at_dcsun4.us.oracle.com> mfriedma_at_oracle.uucp (Mike Friedman) writes:
>From: mfriedma_at_oracle.uucp (Mike Friedman)
>Subject: Re: ASYNC access to ORACLE
>Date: 16 Dec 1994 19:19:38 GMT
>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
Oracle is also releasing with version 7.2 a feature called non-blocking OCI
calls that do just that - send away for info and then do other things in your
app.
Amit Singh
Received on Fri Dec 16 1994 - 15:42:16 CET