SQLPLUS Error Capturing Post: 302528631

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

error connecting to sqlplus

Hi, I wrote a shell script to call oracle procedure. But when i am trying to connet sqlplus with the fallowing statement It is giving me error " callproce.sh : sqlplus: not found". What could be the problem. sqlplus -s $CONNECT_STRING >$LOGFILE <<!! thank u all papachi

2. UNIX for Advanced & Expert Users

Capturing Oracle Shutdown error

Hi, Iam calling 3 sql scripts through one shell script 'rmia.sh'. Till now this was working fine, but last time while calling the SQL scripts, Oracle was down. But amazingly the exit status was '0' (success)!!! Below is the shell code: #!/usr/bin/ksh -x assign_file asql a.sql 1...

3. UNIX for Advanced & Expert Users

Capturing failed FTP error

Hi All, Please check the below ftp related job, which is deleting the files from remote host. Problem is it is not capturing the ftp failure error, and the exit status is still '0' eventhough the deletable files are not present in remote location OR ftp credential are incorrect. ...

4. Shell Programming and Scripting

SQLPLUS error

I am running a script that invokes SQLPLUS. During the execution I get the following: SQL*Plus: Release 9.2.0.8.0 - Production on Mon Jun 11 16:12:50 2007 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.8.0 -...

5. Shell Programming and Scripting

Any suggestion on Capturing SFTP error in log ???

Hello All, I have searched the thread for capturing and got some suggestion but that is not working for me. I am trying to sftp to a window server from unix server and getting file there with out any issue .But i wan't to capture the error --in case a file is not exist in remote. Example :...

6. Shell Programming and Scripting

sqlplus error output to different error log file

HELLO, I am using such a command to write oracle sqlplus query result to text file: sqlplus -S xxx/xxx@xxxxxxx @\tmp\2.sql>\tmp\123.txt Is it possible to script that: If command succesfull write in \tmp\log.txt: timestamp and "succeded" and create 123.txt with results else If error...

7. Shell Programming and Scripting

Capturing the invalid records to error file

HI, I have a source file which has the below data. Tableid,table.txt sourceid,1,2,3,4,5,6 targetid,1,2,3,4,5,6 Tableid,table sourceid,1,2,3,4,5,6 targetid,1,2,3,4,5,6 Tableid,table.txt sourceid,1,2,3,4,5,6 targetid,1,2,3,4,5,6 Tableid,table sourceid,1,2,3,4,5,6 targetid,1,2,3,4,5,6...

8. Shell Programming and Scripting

Capturing Oracle SQL Error Codes

My issue pertains to earlier posts like exit unix script after sqlerror in procedure - dBforums SQLPLUS Error Capturing | Unix Linux Forums | Shell Programming and Scripting We are executing PL/SQL blocks from shell scripts using SQLPLUS. The error code has to be captured into a logfile that...

9. Shell Programming and Scripting

Sqlplus error - sqlplus -s <login/password@dbname> : No such file or directory

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

10. Shell Programming and Scripting

Capturing error codes in SFTP commands

Hi, I have been using the SFTP commands in my reusable shell scripts to perform Get/Put operation. The script has a list of 6 errors which i am capturing through the log file using grep command. But I feel there might me more errors which the script might need to capture. I tried to capture the...

LEARN ABOUT REDHAT

xmsetcolorcalculation

XmSetColorCalculation(library call)									       XmSetColorCalculation(library call)

NAME

       XmSetColorCalculation -- A function to set the procedure used for default color calculation

SYNOPSIS

       #include <Xm/Xm.h>
       XmColorProc XmSetColorCalculation(
       XmColorProc color_proc);

DESCRIPTION

       XmSetColorCalculation sets the procedure to calculate default colors.  This procedure is used to calculate the foreground, top shadow, bot-
       tom shadow, and select colors on the basis of a given background color.	If called with an argument of NULL, it restores the default proce-
       dure used to calculate colors.

       color_proc
		 Specifies the procedure to use for color calculation.

       Following is a description of the XmColorProc type used by XmSetColorCalculation:

       void (*color_proc) (background_color, foreground_color, select_color, top_shadow_color,
       bottom_shadow_color)
	       XColor  *background_color;
	       XColor  *foreground_color;
	       XColor  *select_color;
	       XColor  *top_shadow_color;
	       XColor  *bottom_shadow_color;
       (void)

       Specifies  the procedure used to calculate default colors.  The procedure is passed a pointer to an XColor structure representing the back-
       ground color.  The pixel, red, green, and blue members of this structure are filled in with values that are valid for the current colormap.

       The procedure is passed pointers to XColor structures representing the foreground, select, top shadow, and bottom shadow colors to be  cal-
       culated.   The  procedure  calculates and fills in the red, green, and blue members of these structures.  The procedure should not allocate
       color cells for any of these colors.

       background_color
		 Specifies the background color.

       foreground_color
		 Specifies the foreground color to be calculated.

       select_color
		 Specifies the select color to be calculated.

       top_shadow_color
		 Specifies the top shadow color to be calculated.

       bottom_shadow_color
		 Specifies the bottom shadow color to be calculated.

RETURN

       Returns the color calculation procedure that was used at the time this routine was called.

RELATED

       XmChangeColor(3), XmGetColors(3), and XmGetColorCalculation(3).

													       XmSetColorCalculation(library call)