
	Home > Ask the Oracle Experts > Database Design and Architecture Questions & Answers > Can I make a second connection to Oracle without losing the first?

Ask The Oracle Expert: Questions & Answers

EMAIL THIS

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

EXPERT RESPONSE FROM: Brian Peasland

		Pose a Question

		Other Oracle Categories

		Meet all Oracle Experts
		Become an Expert for this site

Oracle tips, scripts, and expert advice

Digg This! StumbleUpon Del.icio.us

QUESTION POSED ON: 11 July 2007
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.

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

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	Database Design and Architecture
	Why am I getting an Oracle error when issuing the RECOVER DATABASE command?
	Can I add multiple datafiles and make use of all the temporary datafiles at the same time?
	What's the best tape backup strategy for 10g RAC?
	Checkpoint vs. commit process
	How does an INSERT/UPDATE statement behave when executed compared to a SELECT statement?
	Can I resize the SYSTEM tablespace?
	What is the difference between an instance and mounting in Oracle?
	How to implement a ref cursor called in a stored procedure
	In Oracle, does the number of columns in a table affect the performance during SELECT/INSERT/UPDATE?
	Performance issues in Oracle 9i

Oracle stored procedures

Stored procedure to autotransfer data between Oracle servers

Insufficient privileges error when creating stored procedure

ORA-01422 error when procedure returns more than one row

Calling procedure inside another procedure in anonymous block

How to create an index using a procedure in Oracle

Oracle updates Microsoft developer tools

Procedure compiles but does not execute

Tool in Oracle 10g to keep track of execution of queries

ORA-04082: NEW or OLD references not allowed in table level triggers

Execute SQL statement from table in other schema

Oracle Java / J2EE

Unable to view Oracle tables in NetBeans

Oracle updates Microsoft developer tools

Oracle vs. SAP: The SOA factor

Impact of Oracle 9i upgrade on Java front end

Oracle updates free Web development tool

Oracle open sources TopLink at EclipseCon

Why isn't Oracle user-friendly?

Oracle updates free Application Express developer tool

Web Services 101 for DBAs and data architects

Oracle vs. SAP: Picking the right path to SOA

RELATED GLOSSARY TERMS

Terms from Whatis.com − the technology online dictionary

stored procedure (SearchOracle.com)

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.

Browse our Expert Advice
Operating Systems IT Management Networking Database	Security Servers and Storage Applications and Development Career Center

SEARCH

TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.


TechTarget Corporate Web Site \| Media Kits \| Reprints \| Site Map All Rights Reserved, Copyright 2003 - 2008, TechTarget \| Read our Privacy Policy