problem executed shell command from PL/SQL Post: 302086680

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Problem with Calling sql file from shell script

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

2. Shell Programming and Scripting

perl - why is the shell script executed before the print command?

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. Shell Programming and Scripting

Verifying if the shell command executed or not?

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

4. Programming

problem with sql command in pro*c

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

5. Shell Programming and Scripting

How can i use single quotes for SQL command in shell script

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'";...

6. Shell Programming and Scripting

Unix shell command output to a sql statement

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

7. Shell Programming and Scripting

Problem in formatting output of SQL query in excel sheet in shell script

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

8. UNIX for Dummies Questions & Answers

How to send keyboard inputs toa UNIX command executed from a shell script?

I have a unix command that prompts for 'y'. How do I run this from my shell script?

9. Shell Programming and Scripting

awk command not getting executed in shell script

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

10. UNIX for Beginners Questions & Answers

Shell script to check a command executed sucessfully or not

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

LEARN ABOUT DEBIAN

asp-perl

ASP-PERL(1p)						User Contributed Perl Documentation					      ASP-PERL(1p)

NAME

       asp-perl - Apache::ASP CGI and command line script processor

SYNOPSIS

       asp-perl [-hsdb] [-f asp.conf] [-o directory] file1 @arguments file2 @arguments ...

	   -h  Help you are getting now!
	   -f  Specify an alternate configuration file other than ./asp.conf
	   -s  Setup $Session and $Application state for script.
	   -d  Set to debug code upon errors.
	   -b  Only return body of document, no headers.
	   -o  Output directory, writes to files there instead of STDOUT
	   -p  GlobalPackage config, what perl package are the scripts compiled in.

DESCRIPTION

       This program will run Apache::ASP scripts from the command line.  Each file that is specified will be run, and the $Request->QueryString()
       and $Request->Form() data will be initialized by the @arguments following the script file name.

       The @arguments will be written as space separated words, and will be initialized as an associate array where %arguments = @arguments.  As
       an example:

	asp-perl file.asp key1 value1 key2 value2

       would be similar to calling the file.asp in a web environment like

	/file.asp?key1=value1&key2=value2

       The asp.conf script will be read from the current directory for parameters that would be set with PerlSetVar normally under mod_perl.  For
       more information on how to configure the asp.conf file, please see < http://www.apache-asp.org/cgi.html >

SEE ALSO

       perldoc Apache::ASP, and also http://www.apache-asp.org

COPYRIGHT

       Copyright 1998-2004 Joshua Chamas, Chamas Enterprises Inc.

       This program is distributed under the GPL.  Please see the LICENSE file in the Apache::ASP distribution for more information.

perl v5.14.2							    2011-08-15							      ASP-PERL(1p)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Problem with Calling sql file from shell script

Discussion started by: sskc

2. Shell Programming and Scripting

perl - why is the shell script executed before the print command?

Discussion started by: mjays

3. Shell Programming and Scripting

Verifying if the shell command executed or not?

Discussion started by: eamani_sun

4. Programming

problem with sql command in pro*c

Discussion started by: quynhtrang