Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: error in if statement
Top Forums UNIX for Dummies Questions & Answers error in if statement Post 302298629 by Swapna173 on Wednesday 18th of March 2009 07:13:51 AM
Old 03-18-2009
error in if statement
Hi,

This is my script to catch any oracle errors.

In this, the $sqlerr returns
ORA-01017: invalid username/password; logon denied
when i specify wrong username/password

the if condition is failing. how can i resolve the issue.
the if statement gives error
Code:
[: too many arguments

Code:
sqloutput=`sqlplus -s -L $dasDBConnectString @$SqlFiles/testSQLConnection.sql`
		sqlerr=`echo "$sqloutput" | grep "ORA-"`
		echo $sqlerr
		if [ -n $sqlerr ] #sql connection error
		then
			Status=10
		else
			Status=$?
		fi

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

parsing error in if statement

hello, I am trying to parse an error returned by a command inside the if statement but it is just displays the full error instead and then stops. if ; then echo "no such package" else echo "similar version found will use pkgrm" fi the above code just displays please let me know... (2 Replies)
Discussion started by: rakeshou
2 Replies

2. Shell Programming and Scripting

Error with if statement..Please help

:b:hi, I have a script as given below: pr_det="1" if then awk ' BEGIN {printf("%23s","session")}' >> report.txt awk ' BEGIN {printf "\n"} ' >> report.txt else awk ' BEGIN {printf("%55s","file_dsc")} ' >> report.txt awk ' BEGIN {printf("%101s","no_recs")} '... (1 Reply)
Discussion started by: jisha
1 Replies

3. Shell Programming and Scripting

Snytax error on If Statement--help

year=`date '+%Y'` month=`date '+%m'` day=`date '+%d'` day=`expr $day - 1` case $month in 1 | 3 | 5 | 7 | 8 | 10 | 12);; if($day =7 ); then $day=6 fi 4 | 6 | 9 | 11);; if ; then $day=31 fi 2);; if ; then if ; then (2 Replies)
Discussion started by: dannyd_y
2 Replies

4. Linux

error in if statement

Hi , I am getting an error when I run the script for checking word "view" in a file . I am using if statement. like this if then VW_VAR=` cat $TN.${ecmdate}.sql1 | grep -i view | awk '{print $3}' | cut -d '.' -f2 ` echo " VW_$VW_VAR " sed -e... (16 Replies)
Discussion started by: capri_drm
16 Replies

5. Shell Programming and Scripting

Error in IF statement

HI i am getting error while executing the given statement for filename in `cat a/file.lst` do if then echo "Exit Code Description :File $filename - is missing in Input Directory" >a.log exit else count1=`awk 'END {print NR}' $filename` echo "$count1">>a.log count2=`awk 'END {print... (4 Replies)
Discussion started by: ravi214u
4 Replies

6. Shell Programming and Scripting

error in insert statement

hi, When i try to run the code below, i get the following error "ksh: syntax error: `(' unexpected" i am not able to figure it out. Can anyone help me? Code: (2 Replies)
Discussion started by: ragavhere
2 Replies

7. Shell Programming and Scripting

Error in if statement

I am working on script for stale nfs. the file consists of cat data01stale.log - - - - /abcd/backup - - - - /abcd/data Script (16 Replies)
Discussion started by: nareshkumar522
16 Replies

8. Shell Programming and Scripting

If statement Syntax error

Hi Can you please tell me what is wrong with this line: if && ]; then basically i want to check if x = 12 and F (Filename) end with 'g'. But it is throwing syntax error. (7 Replies)
Discussion started by: rtagarra
7 Replies

9. Shell Programming and Scripting

Awk/if statement error

Can anybody tell the correct way to use the following awk pattern check within an if statement? When I run this command outside of the if statement cat /tmp/test2.out | awk -v T=$TIME -v G=$GROUP -v C=$CDATE '$0 ~ T && $0 ~ G && $0 ~ C' | grep -i "Starting the group" I get the following... (0 Replies)
Discussion started by: kieranfoley
0 Replies

10. UNIX for Beginners Questions & Answers

Error code with if statement

hello all im new to unix and when i use below script i get an error : #! /bin/bash Echo -e "enter the name of the file : \c" read file_name if then echo "$file_name found" else echo "$file_name not found" fi running the script i get below error : $ ./hello (26 Replies)
Discussion started by: Ibrahims1
26 Replies

LEARN ABOUT PHP

dbx_escape_string

DBX_ESCAPE_STRING(3)							 1						      DBX_ESCAPE_STRING(3)

dbx_escape_string - Escape a string so it can safely be used in an sql-statement

SYNOPSIS

       string dbx_escape_string (object  $link_identifier, string  $text)

DESCRIPTION

	Escape the given string so that it can safely be used in an sql-statement.

PARAMETERS

	      o $link_identifier
		- The DBX link object returned by dbx_connect(3)

	      o $text
		- The string to escape.

RETURN VALUES

	Returns the text, escaped where necessary (such as quotes, backslashes etc). On error, NULL is returned.

EXAMPLES

       Example #1

	      dbx_escape_string(3) example

	      <?php
	      $link   = dbx_connect(DBX_MYSQL, "localhost", "db", "username", "password")
		  or die("Could not connect");

	      $text = dbx_escape_string($link, "It's quoted and backslashed (\).");
	      $result = dbx_query($link, "insert into tbl (txt) values ('" . $text . "')");
	      if ($result == 0) {
		  echo dbx_error($link);
	      }
	      dbx_close($link);
	      ?>

SEE ALSO

       dbx_query(3).

PHP Documentation Group 												      DBX_ESCAPE_STRING(3)
All times are GMT -4. The time now is 03:22 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy