Summary: I have an expect script that does sftp and the next step I would like to do is to run a database call using sqlplus. Using ksh, I can easily write th...
Summary: Hi, Could anybody please tell why this is happening? sqlplus command works in my user login, but when logged in as root, it won't work. I changed root...
Summary: I want to control the execution of a PL/SQL procedure from a UNIX shell script. Below, I include the script. The control variable which should recive ...
Summary: Hi, I have written a shell script in which I need to connect to sqlplus and execute some query there. In doing so on executing the shell script the qu...
Summary: Your help is much appreciated.In a prompt in Appworx the variable name is SPOOLFILE, so I am moving the path to oSPOOLFILE. The path is {#DS_OUTPUT_D...
Summary: I'm hoping someone can help me or give me a hint on something I've been trying to do for over a week now. When I run the following script (in HP Unix...
Summary: oh oh oh its very hard to work with dates under unix, because there is no spezify tool for it! my solution is, that "we" have a oracle server installe...
Summary: oh oh oh its very hard to work with dates under unix, because there is no spezify tool for it! my solution is, that "we" have a oracle server installe...
Summary: Hi i have written a shell script which runs some sql queries in oracle. the code looks like this sqlplus username@NJCMTOMS/password < $HOME/devel/o...
Summary: Dear Forum, I'm trying to write a script that will check to see if a new file has been written to our server, and if so, execute a procedure in Oracle...
Summary: Hello Thanks david for the help, when I use the mailx command by itself outside the script its emailing the output but when I include it in the scri...
Summary: I do not know DB2, but maybe you can adapt this script for clearing all rows from an Oracle table. Actually, in Oracle, when I want to delete ALL row...
Summary: I am trying to fetch the records from oracle database and write on to xls file for that I did the following. I am trying to run the sql script from ho...
Summary: I have a batch file that starts up the oracle, executes a query and spools the result to a text file and exits. The code goes like this... sqlplus ccn...
Summary: Hello all, I have problems with my shell. I need to get “out” parameter from oracle stored procedure into shell display it. Please, tell me what I...
Summary: Hello All I have a small problem and have no idea how to complete it. I have a script that is colleting all the info I need script below. *********...
Summary: hi, I have scripts which are running every 3 minutes. The scripts include connection to a database, using sqlplus. Sometimes, the connection fails (in...
Summary: Hello all I'm having a little problem. Here is what I'm trying to do. I have many scripts that are running to automate process and I want to make a ...
Summary: My first suggestion is to try to avoid the wrapped lines to begin with. In Oracle sqlplus, increase the width of an output line so that one entire lo...
Summary: Hello, I have a Bourne Shell script that first calls sqlldr then logs into SQL Plus to run a PL/SQL script. However, when I run this script, I nee...
Summary: Hello there, i actually have done this script to connect to a database, spool a file and then execute some other script associated with the database a...
Summary: The most difficult part is to validate the date: 1. with Oracle available: sqlplus /nolog <<EOF > /dev/null CONNECT $ORAUID/$ORAPWD WHENEVER...
Summary: Even if you ultimately need to execute a plsql block after determining that the view has rows, your 10-minute monitoring of the view could use sqlplus...
Summary: 1. How to list the contain of the tape by should of tarring method? ===> tar tvf <tape device> 2. How to extract one of the file from the tape? ===...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
