Shell Programming and Scripting

Guys - Simple code, i am trying to get a number back from sqlplus call to a query. After that, i need to use that number in a loop.

---------------------------------

#!/bin/ksh
VALUE=`sqlplus -silent sh/password@sh <<END
set pagesize 0 feedback off verify off heading off echo off
select max(sequence#) from v\\\$log_history;
exit;
END`

$VALUE=$VALUE + 1

---------------------------------

Problem is, as soon as i use the variable returned from the sqlplus call, it gives me the following error:

bash: $'184\r=': command not found

I have gone through any number of code syntax and i still need help getting this \r guy out of the variable into a new one so i can do some operations on it.

Any help is "GREATLY" appreciated

---------- Post updated at 04:51 AM ---------- Previous update was at 04:35 AM ----------

I am guessing this problem will not be resolved if i spool the output to a file and read it back in?

Any help is appreciated.

Thanks,

this will not work:

Code:

$VALUE=$VALUE + 1

assuming, that "\r" are two printable characters \ and r:

Code:

VALUE='5\r'
VALUE=$(($(echo $VALUE | sed 's/\\r//') +1))
echo $VALUE
6

should work for ksh and bash

cheers

first of all
you specify KSH but the error states you're working in bash

this wotks for me

Code:

@ecarh0u:> value=""
@ecarh0u:> value=`sqlplus -s $user/$pwd@osdp << EOF
more>set pages 0 feed off hea off;
more>select max(sequence#) from v\\\$log_history;
more>exit;
more>EOF
more>`
@ecarh0u:> echo $value
42765
@ecarh0u:> ((value=$value + 1))
@ecarh0u:> echo $value         
42766

Is there a dollar sign before your first occurence of value ($VALUE=$VALUE + 1) or is this your prompt ? If it is a dollar, remove that one.

Thanks, will look into this and post my feedback. Regards and thank you very much for helping out. You guys are great.

Best regards,

Code:

 
#!/bin/ksh
VALUE=`sqlplus -silent "/ as sysdba" <<END
set pagesize 0 feedback off verify off heading off echo off
select max(sequence#) from v\\\$log_history;
exit;
END`
 
VALUE=$VALUE + 1

Replace
$VALUE=$VALUE + 1
with
VALUE=$VALUE + 1
to increment archive log number.

Urs

are you sure? I don't think so...

funksen is right . Both cases are syntax errors and do not do arithmetic.

Also, are you sure about

Assuming that the table is called v$log_history , we only need one backslash to protect the $ from shell.