Home > Ask the Oracle Database / Applications Experts > Oracle 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?

Brian Peasland 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 Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


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


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google



RELATED CONTENT
Oracle database design and architecture
How to use V$SEGMENT_STATISTICS to find the most accessed Oracle table
Can I install an Oracle client on Windows 7?
How to use the Oracle Database Upgrade Assistant (DBUA)
Can I specify Oracle column order in my database table?
Can I have a single Oracle 11g RAC instance across multiple databases?
How to use the Oracle export utility to duplicate database structure
How to choose the primary key columns in an Oracle table
Understanding the data archiving definition
How to plan Oracle Grid Control Repository maintenance
What Linux flavor should I use for my Linux proof of concept in Oracle?

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 and J2EE
Ellison sees new opportunities for Oracle with Java on mobile devices
Oracle and Java: Some think advisory board would comfort users
Will Sun help Oracle eclipse IBM?
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?

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


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.




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



Oracle White Papers: Fusion Middleware
HomeNewsTopicsTipsAsk the ExpertsMultimediaWhite PapersProductsBlogs
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2003 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts