Shell variable truncating the value
<p>I am using this shell script </p>

<pre><code>#!/bin/sh

file_name="'STG_MAP_RM_ARN'"

var_log_tbl_date="'29-MAR-2016'"

var_err_file_list=$($ORACLE_HOME/bin/sqlplus -s obi_user/obi_user@UNNATIDEV
&lt;&lt;
END

set pagesize 0 feedback off verify off heading off echo off;

SELECT WM_CONCAT(A) FROM (SELECT DISTINCT COL15 AS A FROM ERROR_TABLE WHERE FILENAME=${file_name} AND FILEDATE=${var_log_tbl_date});

exit;

END
)

echo $var_err_file_list
</code></pre>

<p>If I am executing the command in sql, the output is:</p>

<blockquote>
  <p>20160727_RM_ARN_MAPPING.csv,YYYYMMDD_RM_ARN_MAPPING.csv,20160728_RM_ARN_MAPPING.csv</p>
</blockquote>

<p>But the shell script output is:</p>

<blockquote>
  <p>20160727_RM_ARN_MAPPING.csv,YYYYMMDD_RM_ARN_MAPPING.csv,20160728_RM_ARN_MAPPING.</p>
</blockquote>

<p>The shell output is getting truncated as you can see (.csv is missing in o/p)</p>

<p>Is there any limitation for variable sizes in Unix?</p>

<p>Please help me</p>