Shell Programming and Scripting

Based on the earlier thread , I made the change for the oracle sequence next val from .sh script ,

Code:

X=$(sqlplus -s user/pswd << eod
set heading off
select etl.batch_sq.nextval from dual;
eod)

when I echo to check the value

Code:

echo Batch_Id_$X

I get the following result :
Batch_Id_ 69 with a space

can someone please let me know what wrong with my step ,
when I try to hard code (override the X value), the value looks file

Code:

 
X=$(sqlplus -s user/pswd << eod
set heading off
select etl.batch_sq.nextval from dual;
eod)
X=23;

Result :

Code:

Batch_Id_23

Thanks In Advance

-

may be your sqlplus command gives the output with space

you can use sed or tr to remove the space

It's a newline, actually (if you quote the echo, you will see it).

Code:

X=$(sqlplus -s user/pswd << eod
set heading off newpage none
select trim(etl.batch_sq.nextval) from dual;
eod)

Wow , it was a simple Trim , it works fine now.
Thanks guys

-