Home » Infrastructure » Unix » Unix Shell
Unix Shell [message #159343] Fri, 17 February 2006 08:55 Go to next message
ricardorq85
Messages: 3
Registered: December 2005
Junior Member
Can I connect to Oracle twice in a shell?
Re: Unix Shell [message #159383 is a reply to message #159343] Fri, 17 February 2006 23:02 Go to previous message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
What do you mean? An interactive shell? No.

You can start a job that connects to Oracle in the background, and then start another one in the foreground - but they are technically separate shells and cannot easily communicate.

Shell script does not have any direct connectivity with Oracle. ie. You can't open a connection, open/close/fetch cursors etc without using another language (eg. Perl / Java) or tool (eg. SQL*Plus). SQL*Plus cannot make multiple connections (although it can emmulate them using DB Links). Languages with real DB connectivity can make multiple connections. For example, in Perl (DBI), just open a second database handle.

_____________
Ross Leishman
Previous Topic: ORA-01555 in HP-UX
Next Topic: How to compare data in two flat files and update them?
Goto Forum:
  


Current Time: Thu Mar 28 11:58:32 CDT 2024