Re: Trying to write a short script

From: Subodh Deshpande <deshpande.subodh_at_gmail.com>
Date: Fri, 23 Sep 2011 10:07:28 +0530
Message-ID: <CAJsOtB4JpEfjcE_XRAQVroMXUwVg8KhK=vhbJa6jWFdUh+peWA_at_mail.gmail.com>

try set lines n (where n can be 80, 100, 132 etc) you may executing be below script from server... execute the sql text from any client..you will get it proprely..

thanks and take care..subodh

On 23 September 2011 02:13, Laurent, Vincent <Vince_Laurent_at_ssmhc.com>wrote:

> I am currently using Oracle 11.2.0.2 on HP-UX 11.31
> I have a script that does this:
>
> # Get the path to the trace files
> DUMP=`/oracle/$ORACLE_SID/112_64/bin/sqlplus -s / as sysdba <<EOF
> set head off
> set feedback off
> select * from v\\$version;
> exit
> EOF`
> echo $DUMP
>
> but the output comes back like this (all wrapped as one line):
>
> Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit
> Production PL/SQL Release 11.2.0.2.0 - Production CORE 11.2.0.2.0 Production
> TNS for HPUX: Version 11.2.0.2.0 - Production NLSRTL Version 11.2.0.2.0 -
> Production
>
> Instead of like this (each product it's own line):
>
> Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit
> Production
> PL/SQL Release 11.2.0.2.0 - Production
> CORE 11.2.0.2.0 Production
> TNS for HPUX: Version 11.2.0.2.0 - Production
> NLSRTL Version 11.2.0.2.0 - Production
>
> Ideas to fix?
>
>
>
> Confidentiality Notice: This email message, including any
> attachments, is for the sole use of the intended recipient(s) and
> may contain confidential and privileged information. Any
> unauthorized review, use, disclosure or distribution is prohibited.
> If you are not the intended recipient, please contact the sender by
> reply email and destroy all copies of the original message.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
==============================
DO NOT FORGET TO SMILE TODAY
==============================


--
http://www.freelists.org/webpage/oracle-l

Received on Thu Sep 22 2011 - 23:37:28 CDT