Re: [Q]: background query processing in Oracle?

From: Tony Rothwell <Tony_at_santen.demon.co.uk>
Date: Sun, 22 Jan 1995 16:34:38 +0000
Message-ID: <790792478snz_at_santen.demon.co.uk>


In article <790658110snz_at_rico.demon.co.uk>

           Karl_at_rico.demon.co.uk "Karl Hampson" writes:

> In article <3fk5hs$1lq_at_www.interramp.com> bendermac_at_interramp.com writes:
>
> >
> > Hi:
> > I am looking for a way of somehow "detaching" the execution of SQL code from
> >
> > the client's process, namely some way of allowing the code to execute in the
> >
> > background. Sybase supports this feature. How about Oracle?
>

 [stuff deleted]
> Just wanted to give you a taste of the kind of area you're entering if you
> want this kind of functionality. Obviously it all depends on exactly how
> complex your requirement is. You may just be talking about forking/execing your
> client process and using pipes!
>
> Hope this gives you a little insight into the issues. If you want to elaborate
> on your problem I'll try and help further.

Hi Asim

If it's non-blocking Server calls that you're after, Oracle7 Release 7.2 (mid '95?) supports these from the OCI (Oracle Call Interface). From your question, it sounds like Sybase might already do this.

If you can't wait that long, then you'll have to code your way around this as Karl described.

Tony.


Tony Rothwell                                          tony_at_santen.demon.co.uk
Received on Sun Jan 22 1995 - 17:34:38 CET

Original text of this message