08-25-2006
problem executed shell command from PL/SQL
i wrote plsql procedure that executed shell command
using java class
my problem is that in some reason
the shell command ( liks Is -l , mv ... ) are not recordnize
can someone help me with that
10x
Alodvg
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have created abc.sh file which will set the environment variables (UNIX env variables as well as ORACLE required variables like ORACLE_SID,ORACLE_HOME etc) and then calls a function file which checks for starts some logs and then it will try to execute the .sql file. The .sh, function file are as... (1 Reply)
Discussion started by: sskc
1 Replies
2. Shell Programming and Scripting
i'm writing some simple scripts to help me learn perl.
why does the print command get called after the shell script is executed?
the purpose of the shell script is to simply echo to the screen "script run". which is does, but before the print command, you can clearly see the shell script is... (3 Replies)
Discussion started by: mjays
3 Replies
3. Shell Programming and Scripting
Hi,
I am working on a shell script that would verify if the mount command has executed or not. So , i have been doing this.
mount /dev/cdrom /mnt/cdrom
echo "$?"
if ; then
echo " Mount succesful"
else
echo " Mount unsuccessful"
fi (3 Replies)
Discussion started by: eamani_sun
3 Replies
4. Programming
In a pro*C program, I use query follow:
INSERT INTO radacct_wk
SELECT (select psid from cscterminfo where cscterminfo.TELNO = username), nasipaddress, acctstarttime, acctstoptime,
acctsessiontime, acctinputoctets, acctoutputoctets, acctterminatecause, framedipaddress
FROM radacct@DBSV_B;... (7 Replies)
Discussion started by: quynhtrang
7 Replies
5. Shell Programming and Scripting
Hi.
please help me to write the following query in a shell script.
the Query is :select no,salary from emp_info where name='$var_name'
the following is my code.
#! /bin/sh
var_name=$1
sqlplus -s user/pwd@DB << EOF
select no,salary from emp_info where name="'$var_name'";... (4 Replies)
Discussion started by: little_wonder
4 Replies
6. Shell Programming and Scripting
Can i do this
Say one command
sed 's/:*/ /g' $summf
is returning
C1234
C2345
C3434
some no of rows, now this ouput i have to insert it into a DB table
how do i do this?? (2 Replies)
Discussion started by: depakjan
2 Replies
7. Shell Programming and Scripting
Hi Guys..
Need your help to format the output of my shell script.
I am using spool command to take out put in csv file.
below is my code. (for example)
col USERNAME for a15
col EMAIL for a30
col FULL_NAME for a20
col LAST_LOGIN for a40
col DATE_CREATED for a40
SPOOL 120.csv... (3 Replies)
Discussion started by: Agupte
3 Replies
8. UNIX for Dummies Questions & Answers
I have a unix command that prompts for 'y'. How do I run this from my shell script? (4 Replies)
Discussion started by: Sree10
4 Replies
9. Shell Programming and Scripting
I am able to execute awk command from shell prompt. but the same command is not getting executed when written and run in a bash script
the command from bash cmd prompt.
awk '/world/{for (i=2; i<NF; i++) printf $i " "; print $NF}1' myfile >tmp$$ ; mv tmp$$ myfile
file:
# hello world my... (4 Replies)
Discussion started by: ashima jain
4 Replies
10. UNIX for Beginners Questions & Answers
Hi All,
I am trying to write a shell script to check if a command executed successfully or not in rhel 7 and finding the installed tomcat version.
I am using below script.
var4=$(find / -name "catalina.jar" ! -size 0 |egrep -v... (6 Replies)
Discussion started by: sravani25
6 Replies
chsh(1) General Commands Manual chsh(1)
NAME
chsh - change default login shell
SYNOPSIS
login-name [shell]
login-name [shell]
login-name [shell]
login-name [shell]
DESCRIPTION
The command changes the login-shell for a user's login name in the repository (see passwd(1)).
The DCE repository is only available if Integrated Login has been configured; see auth.adm(1M). If Integrated Login has been configured,
other considerations apply. A user with appropriate DCE privileges is capable of modifying a user's shell; this is not dependent upon
superuser privileges.
If the repository is not specified (as in [login-name]), the login shell is changed in the file only.
Run after running to make sure the information was processed correctly.
Notes
The command is a hard link to the command. When is executed, actually the command gets executed with appropriate arguments to change the
user login shell in the repository specified in command line. If no repository is specified, the login shell is changed in the file.
Arguments
login-name A login name of a user.
shell The absolute path name of a shell. If the file exists, the new login shell must be listed in that file. Otherwise, you
can specify one of the standard shells listed in the getusershell(3C) manual entry. If shell is omitted, it defaults to
the POSIX shell,
Options
The following option is recognized:
Specify the repository to which the operation is to be applied.
Supported repositories include and
Security Restrictions
You must have appropriate privileges to use the optional login-name argument to change another user's login shell.
NETWORKING FEATURES
NFS
File can be implemented as a Network Information Service (NIS) database.
EXAMPLES
To change the login shell for user to the default:
To change the login shell for user to the C shell:
To change the login shell for user to the Korn shell in the DCE registry:
WARNINGS
If two or more users try to write the file at the same time, a passwd locking mechanism was devised. If this locking fails after subse-
quent retrying, terminates.
AUTHOR
was developed by HP and the University of California, Berkeley.
FILES
SEE ALSO
chfn(1), csh(1), ksh(1), passwd(1), sh(1), sh-posix(1), getusershell(3C), pam(3), passwd(4), shells(4).
chsh(1)