supress old/new lines in SQL*Plus scripts

From: Steve Mitchell <stevem_at_hdcsi.com>
Date: Fri, 23 Aug 2002 19:09:48 GMT
Message-ID: <0Mv99.407$t26.31363389_at_newssvr21.news.prodigy.com>


[Quoted] 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, [Quoted] 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
Received on Fri Aug 23 2002 - 21:09:48 CEST

Original text of this message