Hi Sunny,
Thanks for your help.
It seems to be the answered for me ;)
But I still hit one problem here,
I tried to invoke the SQL statement from my package.
and when I compile the package,
It keeps giving me the error message :
PLS-00201: identifier 'SYS.V_$SESSION' must be declared
any idea
Hi jesse,
For no 1, Thanks a million, it works fine
For no 2, yes, I saw the sticky bit in the oracle file.
is it advisable for us to change the oracle file permission
/ to turn off the sticky bit ?
Would it affect oracle internally ?
Thanks for Sunny too,
I'm
You can use remote login rlogin and run the shell script which you need to
run on the remote Unix machine. You dont have to pass any password while
using rlogin command. See the help for rlogin for how to set it up..
-Original Message-
Susantio
Sent: Monday, December 10, 2001 2:45 PM
You can use remote login rlogin and run the shell script which you need to
run on the remote Unix machine. You dont have to pass any password while
using rlogin command. See the help for rlogin for how to set it up..
-Original Message-
Susantio
Sent: Monday, December 10, 2001 2:45 PM
:
.comSubject: Re: Unix account from PL/SQL ??
Sent by:
[EMAIL PROTECTED
of the questions you've asked.
Jared
Herman
SusantioTo: Multiple recipients of
list ORACLE-L [EMAIL PROTECTED]
sherman@bcsis cc:
.comSubject: Re: Unix account
from PL/SQL
Assuming you're on Oracle 8i (you don't say):
1) select SYS_CONTEXT('USERENV','OS_USER') from dual;
2) I believe this is because the $ORACLE_HOME/bin/oracle executable has
an owner of oracle and has the sticky bit set on it's security. If you
ls -l $ORACLE_HOME/bin/oracle, you should