This is my first post and I would be very thankful if you can help me. I've already searched in the forum and I've found a very similar thread in wich my problem is solved, but the thread is closed and the solution given in it doesn't work in my shell:
153194-problem-quitting-sqlplus
(Sorry but the system doesn't allow me to post complete URLs).
My script is the following:
The first "if" works properly but the second one doesn't, and "COUNT1" is greater than zero. Of course, the query is also redirected to the file "output". I've also tried using "EXIT" instead of "quit" but it neither works.
Could you help me?
Thanks!
Last edited by JuanPerez; 08-28-2012 at 09:38 AM..
Hi,
trying this
===============================
Temp=`sqlplus -s user/passwd <<EOF
WHENEVER SQLERROR EXIT 1
set serverout on
set feedback off
set heading off
select nam from tabel1
where x=y;
EOF`
echo Temp>>$logfile
=================================
The select statement is... (2 Replies)
Hi all,
Iam facing a lot of problem while calling Oracle 10g SQLPLUS files from shell.
What is the standard procedures to be taken care.
Any help would be useful for me.
Thanks in advance,
Ganapati. (2 Replies)
Ok. So I've finally compiled the latest version of GNU emacs on Solaris 5.8.
I've set putty up so that it sets TERM=xtermc. emacs now has syntax highlighting. The problem is, whenever I quit emacs, it changes the screen colors. The background is now the same as the color of the minibuffer. It... (1 Reply)
Hi my code looks like:
if test $STEP -le 10
then
.
.
ls -1d AM*-OUT|while read MYDIR
do
cd $MYDIR
ls |tail -n1| while read MYFILE
do
.
.
if test -s $MYFILE
then
sqlldr ....
rc=$?
if test $rc -ne 0 (3 Replies)
This is a very simple problem, I am wondering why I can find no answer anywhere...
I have a script that can be run either sourced or not. This script has some place where it needs to quit execution (e.g., when an error is found)
If I "exit", the sourced call would exit the parent shell, but... (7 Replies)
Folks,
Below is a basic synopsis of the problem. I have a script that I need to check for some env vars and fail (exit the script) if they are not there. At the same time I need to set some default env vars. To do this I must run the script from the parent shell or source the script. Doing... (3 Replies)
Hi all,
I have a scenario where im connecting to sqlplus executing a query,redirecting the output to a file and manipulating the file
MY CODE IS AS FOLLOWS
sqlplus -s /nolog << EOF > $UTILITIES_HOME/temp/analyze.temp.log &
set linesize 3000
set trimspool on
set pagesize... (2 Replies)
sql_rows=`sqlplus -s / <<EOF
set heading off
set pagesize 1000
set tab off
set linesize 120 wrap off
column "Path" format a15
--column "No_Of_files" format a10
select tablespace_name, substr(file_name,1,instr(file_name,'/',1,2)) as "Path" , count(*) as "No_Of_files" from dba_data_files
... (7 Replies)
Hi guys,
Here is the error i get by running a "sqlplus -v" after installing an oracle client 10.2.0.5 on an AIX 5.3.9 server.
Could not load program sqlplus:
Symbol resolution failed for sqlplus because:
Symbol __pthread (number 307) is not exported from dependent
... (3 Replies)
Hi I am having a problem exiting a WHILE loop. I am on a Sun server using ksh.
I am running a Veritas Cluster Software (High Availablity) command to obtain a group status and grepping the command output for status "G" which means that the filesystem is frozen and therefore not available to... (3 Replies)
Discussion started by: bigbuk
3 Replies
LEARN ABOUT ULTRIX
xlator_call
xlator_call(8) System Manager's Manual xlator_call(8)Name
xlator_call - shell script to invoke PostScript translators
Syntax
xlator_call datatype orientation pagesize width length indent
Description
This Bourne shell script can be called by the line printer daemon to invoke the appropriate translator to convert each data type to Post-
Script. The data type passed by may be specified by using the command with the -Ddatatype option, or by using the Da=datatype capability
in the file.
For a file in a data syntax to be translated to PostScript, the script must contain a case branch which recognizes the data type string and
calls a suitable filter. The supplied recognizes the ANSI, ASCII, ReGIS and Tektronix 4014 data types.
Arguments
datatype
The valid data types are: or any other for which a translator has been installed.
orientation
The valid orientations are: portrait or landscape.
pagesize
The valid page sizes are: or
width
The width (in characters) of the page.
length
The length (in lines) of the page.
indent
The amount (in spaces) the output is to be indented.
All the valid arguments are described in detail by the reference page.
Examples
An example shell script is shown below:
case $datatype in
ansi)
exec ansi_ps -F $pagesize -O $orientation -e "$@";;
ascii)
echo "( 04) cvn {} def"
exec ln03rof -w$width -l$length -i$indent;;
postscript)
exec cat;;
tek4014)
exec tek4014_ps -F $pagesize -O $orientation;;
regis)
exec regis_ps -F $pagesize -O $orientation;;
*)
echo "$0: Translator for data type $datatype not installed" >&2
esac
When the shell script is called, the path searched is:
/usr/local/lib/lpdfilters:/usr/ucb:/bin:/usr/bin:
/usr/lib:/usr/lib/lpdfilters
Files
The script
See Alsolno3rof(8), printcap(5), ansi_ps(8), lpd(8)xlator_call(8)