Script is Returning a Leading Space to Value (Doc ID 466806.1)

Last updated on MARCH 08, 2017

Applies to:

SQL*Plus - Version: 10.2.0
This problem can occur on any platform.

Symptoms

Running script with silent mode of sqlplus, result has an extra space.

Example script:
-----------
jimtest=`sqlplus -s scott/tiger <<EOF
set heading off feedback off verify off
select 'jim' from dual;
exit
EOF`
echo jimtest=$jimtest

The result is:
jimtest= jim
- It has space.



Issue Verification (jgarand.us 09-Nov-2007 12:16 EST)



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms