Q
Problem solve Get help with specific problems with your technologies, process and projects.

Can I make a second connection to Oracle without losing the first?

Is it possible to have a stored procedure make a second connection to Oracle without losing where you're at in the first connection?

Is it possible to have a stored procedure make a second connection to Oracle without losing where you're at in the first connection? I'm looking for something akin to Unix sub sessions for verifying id/passwords by actually logging on and not by just doing a lookup.
Unfortunately, there is no such mechanism natively in Oracle. However, you can create a Java Stored Procedure in Oracle which executes the SQL*Plus command line executable. This Java Stored Procedure can test the id/password combination this way and then return the results back to the calling procedure. Go to Ask Tom to see examples of how to use a Java Stored Procedure in this manner.
This was last published in July 2007

Dig Deeper on Oracle database design and architecture

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close