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.


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

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

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

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


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