title: Passing an out clob procedure parameter as it is to a shell variable
body: <p>I have a procedure that takes a clob as an out parameter.</p>
  
  <p>I want to pass the clob content to the shell variable so that I can print it in a file, as it is in one line, but I got a different result : some blanks are deleted, and the result is printed in many lines!</p>
  
  <p>This is the shell code : </p>
  
  <pre><code>#!/bin/bash
  date_fich_ent=`date '+%Y%m%d'`;
  heure_fich_ent=`date '+%H%M'`;
  FILE_NAME="RIA_BMCE_TRX_${date_fich_ent}${heure_fich_ent}.TXT";
  
  function_output=`sqlplus -s &lt;&lt;END
  $1/$2@$3
  set feedback off
  set heading off
  set pagesize 0
  set serveroutput on 100000
  DECLARE
  
    my_clob clob := null;
  
  BEGIN
    proc_test('it',my_clob);
    dbms_output.put_line(my_clob);
    END;
    /
  exit;
  END`
  
  echo "$function_output" &gt; $FILE_NAME
  </code></pre>
  
  <p>Thanks.</p>