| Author |
Cam i set catalog on connection with oracle
|
avihai marchiano
Ranch Hand
Joined: Jan 10, 2007
Posts: 342
|
|
Hey,
lets say i have a connection that i get from data source.
The connection is to user XXX.
can i change the user in run time?
In my sql i point the data source to localhost:3306 and set the schema (catalog) in run time, can i do something like this in oracle?
|
 |
Jeanne Boyarsky
internet detective
Marshal
Joined: May 26, 2003
Posts: 26193
|
|
Avihai,
No. The connection is tied to a specific user. To change user, you need to get a new connection.
This is similar to how you have to reconnect to login with a different user id at the sql plus command line.
|
[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
|
|
 |
|
|
subject: Cam i set catalog on connection with oracle
|
|
|
0
