log_id=$(sqlplus -s /nolog <<-EOF|awk 'NR==2 {print $1}'
                set head off
                set feed off
                set pagesize 0
                conn $DBCONN_AUDIT
                select pls_audit.get_id_log from dual;
#EOF)

awk -F\t

awk '-F\t'

$ cat /etc/*{release,version}
                   Oracle Solaris 10 9/10 s10s_u9wos_14a SPARC
     Copyright (c) 2010, Oracle and/or its affiliates. All rights reserved.
                            Assembled 11 August 2010

Oracle 10

$ uname -a
SunOS nap7-plsm5k-1 5.10 Generic_144488-10 sun4u sparc SUNW,SPARC-Enterprise

Oracle 11g

+ sqlplus -s /nolog
+ awk NR=='2 {print $1}'
+ 0<< \EOF
                set head off
                set feed off
                set pagesize 0
                conn user1/password1@plspro
                select pls_audit.get_id_log from dual;
EOF
+ log_id=''
+ sqlplus /nolog
+ 0<< \EOF

SELECT pls_audit.get_id_log from dual

2225700 

echo -e "conn user1/pass1@plspro\nselect pls_audit.get_id_log from dual;" | sqlplus -s /nolog
GET_ID_LOG
----------
  33363309