 | |
How to Get User Environment in Sqlplus?
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
How to Get User Environment in Sqlplus? -
10-01-2003
, 05:30 PM
#2
| |||
| |||
|
|
I run Oracle 8.1.7.2 on in AIX 4..3.3. When I run sqlplus and use ! or host to spawn a shell and execute an AIX command my environment and aliases don't seem to be present. How can incorporate the user environment to AIX commands run from sqlplus? Thanks. Mine are (AIX 5L). cd. $ORACLE_HOME works just fine. |
--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)
#3
| |||
| |||
|
|
I run Oracle 8.1.7.2 on in AIX 4..3.3. When I run sqlplus and use ! or host to spawn a shell and execute an AIX command my environment and aliases don't seem to be present. How can incorporate the user environment to AIX commands run from sqlplus? Thanks. |
Are they there if you spawn a shell directly, independent of sqlplus ?
eric
--
Remove the dross to contact me directly
#4
| |||
| |||
|
|
"Eric Parker" <eric.parkerthedross (AT) virgin (DOT) net> wrote in message news:ScSeb.4895$QH3.2409 (AT) newsfep4-winn (DOT) server.ntli.net... "Tiglath" <tiglath (AT) tiglath (DOT) net> wrote in message news:blf9ho$q0e$1 (AT) bob (DOT) news.rcn.net... I run Oracle 8.1.7.2 on in AIX 4..3.3. When I run sqlplus and use ! or host to spawn a shell and execute an AIX command my environment and aliases don't seem to be present. How can incorporate the user environment to AIX commands run from sqlplus? Thanks. Tiglath Are they there if you spawn a shell directly, independent of sqlplus ? Thank you for your reply. Yes, all the aliases in .kshrc are present when I spawn a new ksh outside sqlplus, but missing within sqlplus. Why would you expect it to be otherwise? |
--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)
#5
| |||
| |||
|
|
"Tiglath" <tiglath (AT) tiglath (DOT) net> wrote in message news:blf9ho$q0e$1 (AT) bob (DOT) news.rcn.net... I run Oracle 8.1.7.2 on in AIX 4..3.3. When I run sqlplus and use ! or host to spawn a shell and execute an AIX command my environment and aliases don't seem to be present. How can incorporate the user environment to AIX commands run from sqlplus? Thanks. Tiglath Are they there if you spawn a shell directly, independent of sqlplus ? |
Yes, all the aliases in .kshrc are present when I spawn a new ksh outside
sqlplus, but missing within sqlplus.
#6
| |||
| |||
|
|
Why would you expect it to be otherwise? |
1. Because the user having the problem reports that such was the standard behaviour until somehow it stop working.
2. Because it is the intelligent thing to do. If you exec the ksh it certainly doesn't bring the environment, but the exec system call has plenty of provisions for doing so.
Why would you expect that it is sensible to disconnect from the environment when you use the shell from within sqlplus?
--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.