generate_csv ()
{

sqlplus -S $USER/$PASSWD@$ORACLE_SID <<EOF > /opt/oracle/reports/service_report_.$(/bin/date '+%d%m%Y.%Hh')

set echo Off
set term On
set pages 0
set head off
set ver off
set feed off
set trims on
set linesize 20000

SELECT    serial
   || ';'
   || upd_time
   || ';'
   || MESSAGE
   || ';'
   || entity_table
   || ';'
   || action
   || ';'
   || rss_name
   || ';'
   || rss_type
   || ';'
   || admin
   || ';'
   || ess_user
   || ';'
   || origin
   || ';'
   || rss_user_name
   || ';'
   || ug_name
   || ';'
   || original_command
  FROM trans
[...]

exit
EOF
}