Re: supress old/new lines in SQL*Plus scripts

From: Steve Mitchell <stevem_at_hdcsi.com>
Date: Fri, 23 Aug 2002 21:59:26 GMT
Message-ID: <2fy99.6$mL6.174230_at_newssvr21.news.prodigy.com>


Thanks, that solved my problem.

--steve

"TurkBear" <jgreco1_at_mn.rr.com> wrote in message news:7p5dmugfnh4eub36cojc06ltdust6uv9h8_at_4ax.com...
> If you are using scripts, I assume you have a manual handy..
> if not, try
>
> Set verify off
>
>
>
> at the start of your scripts..
>
>
>
> "Steve Mitchell" <stevem_at_hdcsi.com> wrote:
>
> >
> >I have a suite of scripts I use to perform common queries. I use &1, &2,
> >etc., to do parameter replacement within these scripts. This works
great,
> >but SQL*Plus has this annoying habit of printing out the old line and the
> >new line before and after the replacement respectively. I would like to
> >suppress this somehow:
> >
> >company_42_at_dilbert> @chargetag 1439
> >old 6: voucherhdridx = &1
> >new 6: voucherhdridx = 1439
> >
> >VOUCHERHDRIDX VENDNAMEIDX VENDINVCNO VENDINVCDATE
> >------------- ----------- ------------ -----------------
> > 1439 13 08/20/2002 000000
> >
> >
> >Thanks for any pointers.
> >
> >--steve
> >
> >
>
>
>
> -----------== Posted via Newsfeed.Com - Uncensored Usenet News
==----------
> http://www.newsfeed.com The #1 Newsgroup Service in the World!
> -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers
=----- Received on Fri Aug 23 2002 - 23:59:26 CEST

Original text of this message