Re: Using Same connect by different process

> >
> >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.

Shankar.
>
> -----------------------------
>
Received on Thu Aug 25 1994 - 19:32:03 CEST