setting default connection

From: Brent Moore <bdmoore_at_my-deja.com>
Date: Fri, 19 Nov 1999 17:15:37 GMT
Message-ID: <8140jc$ujm$1@nnrp1.deja.com>

I have a 'c' server process that opens a number of database connections, then waits for clients to connect. When a client connects, the server forks a child to handle the request and assigns one of the connections for it to use.

We are using
exec sql connect :uname identified by :pwd at :sess using :DB;

In the Ingres world we came from, I could the child process could then tell Ingres that the connection it was given is the default for this process. Is there a way to do this in Oracle. We know that we can specify the "AT clause" on each exec sql statement for the child, but we also have servers that do not connect using the "AT clause" and would like to keep the code the same, and avoid having two sets of code.

Any help would be appreciated

Brent Moore
Brigham Young University

--
If I knew what I was doing, it wouldn't be half the fun....

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Nov 19 1999 - 11:15:37 CST