|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
[Solved] While loop error when add sqlplus command
Post 302869343 by kunal37 on Wednesday 30th of October 2013 06:32:47 AM
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all,
I am using the below given sqlplus command in my unix script to invoke a stored procedure which returns a value .It works fine.
RET_CODE=$(/opt/oracle/product/10.2.0.4.CL/bin/sqlplus -S $USER/$PASSWD@$DB_NAME <<EOF
EXEC MY_PKG.MY_SP (:COUNT);
PRINT COUNT;
commit;
... (6 Replies)
Discussion started by: Shri123
6 Replies
2. Shell Programming and Scripting
I have shell script which will try to login to SQL Plus and retrieve some data, based on the outcome i will proceed further
Below is the content of the file
pebblz02% cat test1.ksh
#! /bin/ksh
dummyvar=`sqlplus -S csm_admin/csm_admin@SIDNAME <<EOF echo hi; exit; EOF`
Error message on... (0 Replies)
Discussion started by: kiranlalka
0 Replies
3. Shell Programming and Scripting
I tried this:
for region in 'raj' 'kt' 'kol' 'krl' 'chn' 'dl' 'hr' 'bih' 'ap'
do
sqlplus -s huw$region/`echo $region`huw#321@huw$region<<!
set serveroutput on
begin
select count(*) from tcd_preferred_cust_201109
end;
/
exit;
done
but the error shows like:
Syntax error at line 4 :... (1 Reply)
Discussion started by: deepakprasad29@
1 Replies
4. UNIX for Dummies Questions & Answers
can some one please tell me what is the problem with my syntax:confused:
I have 100 files in one folder
1. want to read each of the line by line
2. calculate their number of the words between the first word and the last word of each line
3. create file for each file with number of words... (8 Replies)
Discussion started by: A-V
8 Replies
5. UNIX for Advanced & Expert Users
Hi,
Again a question about virt-install.
Someone knows how to add hardware in the virt-install command?
I put the first disk with --disks path=/.... but I need a second disk and I don't know how to include it?
Thanks (2 Replies)
Discussion started by: hiddenshadow
2 Replies
6. Shell Programming and Scripting
I have a script that reads a file containing a list of server names. It's suppose to loop through the list of names and execute a command on the remote server using ssh. It processes the ssh command for the first server in the list and then exits. Here's the code:
#!/bin/bash
... (2 Replies)
Discussion started by: westmoreland
2 Replies
7. Shell Programming and Scripting
Hi All,
I have a file which has hundred of records with fixed number of fields. In each record there is set of 8 characters which represent the duration of that activity. I want to sum up the duration present in all the records for a report. The problem is the duration changes per record so I... (5 Replies)
Discussion started by: danish0909
5 Replies
8. Solaris
I am using following code to connect to oracle database from solaris shell script. which will try thrice to connect the database ...at the 4rth atempt it will exir=t.
count=0
while ; do
sqlplus -s $usrname/$password@dbSID <<-EOF | tee $logfile
WHENEVER OSERROR EXIT 9;
WHENEVER SQLERROR... (4 Replies)
Discussion started by: millan
4 Replies
9. Shell Programming and Scripting
The code at the bottom is a simplified example of what we have.
If I use the following:
&& echo "echo failed"
$? returns 1
When I use
if ; then echo "echo failed" ; fi
$? returns 0
Does anyone know what's wrong with this?
Using AIX 6.1 and KSH
for NUM in 1 2 3
do
... (5 Replies)
Discussion started by: jfxdavies
5 Replies
10. Shell Programming and Scripting
i am using bash shell
Whenever i declare an array, and then using sqlplus, i am getting sqlplus error and return code 127.
IFS=","
declare -a Arr=($Variable1);
SQLPLUS=sqlplus -s "${DBUSER}"/"${DBPASS}"@"${DBASE}
echo "set head off ; " > ${SQLCMD}
echo "set PAGESIZE 0 ;" >> ${SQLCMD}... (6 Replies)
Discussion started by: arghadeep adity
6 Replies
LEARN ABOUT HPUX
xcmssetwhia
XcmsSetWhiteAdjustProc() XcmsSetWhiteAdjustProc()
Name
XcmsSetWhiteAdjustProc - change the white point adjustment procedure in a specified Color Conversion Context.
Synopsis
XcmsWhiteAdjustProc XcmsSetWhiteAdjustProc(ccc, white_adjust_proc,
client_data)
XcmsCCC ccc;
XcmsWhiteAdjustProc white_adjust_proc;
XPointer client_data;
Arguments
ccc Specifies the color conversion context.
client_data
Specifies client data for the white point adjustment procedure or NULL.
white_adjust_proc
Specifies the white point adjustment procedure.
Returns
The previous white point adjust procedure.
Availability
Release 5 and later.
Description
XcmsSetWhiteAdjustProc() sets a new white point adjustment procedure and client data in the specified CCC, and returns the old procedure.
White adustment procedures provided with Xlib and intended for use with XcmsSetWhiteAdjustProc() are:
o XcmsCIELabWhiteShiftColors - Uses the CIELAB color space to shift the chromatic character of colors by the chromatic displacement
between the initial and target white point. No client data is necessary.
o XcmsCIELuvWhiteShiftColors - Uses the CIELUV color space to shift the chromatic character of colors by the chromatic displacement
between the initial and target white point. No client data is necessary.
o XcmsTekHVCWhiteShiftColors - Uses the TekHVC color space to shift the chromatic character of colors by the chromatic displacement
between the initial and target white point. No client data is necessary.
See Also
XcmsCCCOfColormap(), XcmsCreateCCC(), XcmsClientWhitePointOfCCC(), XcmsConvertColors(), XcmsDefaultCCC(), XcmsScreenWhitePointOfCCC(),
XcmsSetCompressionProc(), XcmsSetWhitePoint().
Xlib - Device-independent Color XcmsSetWhiteAdjustProc()