Re: Using Same connect by different process
Date: Thu, 25 Aug 1994 17:32:03 GMT
Message-ID: <Cv3Ks5.BJF_at_deere.com>
> >
> >How can we use the same rolback segment from
> >two different processes? In other words, how can we
> >connect to the database from one process and let other
> >process use the same 'connect'? To make it more clear, we
> >want a process to see all the changes made by a different
> >process without commiting.
> >
> >Shirish Kumar
> >817 963 2867
> >
> >Environment:
> >ORACLE7 7.0.15.4, PRO*C
> >on SUN OS 5.3
> >
> >
> >
I have done this before. We used to log in only once in the main application.
All the other process's uses the database id ? (handle) to identify the
database.
I am writing this from what I remember. It looks like years ago I wrote this
(which is true). if you need exect code I can probably
dig up from my pile. The key is ....
"When you do the connect, save the handle returned to you , I think this is
your database id. Pass this to your child process, (don't log in again)". You should be able to do this.I hope this will help you...
Shankar.
>
> -----------------------------
>
Received on Thu Aug 25 1994 - 19:32:03 CEST