Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Turning off substitution output

Turning off substitution output

From: <watsonr4_at_my-deja.com>
Date: Tue, 16 Nov 1999 15:21:20 GMT
Message-ID: <80rsp9$2ik$1@nnrp1.deja.com>


Hi:
I'm running a Unix script file, that calls a simple PL-SQL file, that calls a stored PL-SQL procedure. The script file accepts 3 parameters, which it passes to the PL-SQL file. The problem I'm having is that when the script file passes the parameters to the PL-SQL file, it shows the "old" and "new" lines in the PL-SQL file where the parameters are used. Here is the output that is displayed:

running .kshinit
Tue Nov 16 10:20:25 EST 1999

old   2:     user        VARCHAR2(20) := '&1';
new   2:     user        VARCHAR2(20) := 'rlw';
old   3:     start_log   VARCHAR2(10) := '&2';
new   3:     start_log   VARCHAR2(10) := 'L9911000';
old   4:     end_log     VARCHAR2(10) := '&3';
new   4:     end_log     VARCHAR2(10) := 'L9911999';
Tue Nov 16 10:21:57 EST 1999

Is there a way to prevent this from displaying (except for the dates)? I've tried ECHO OFF, SET FEEDBACK OFF, and the "silent mode" in the command line when running the PL-SQL program. None of these work.

Any help is appreciated.

Thanks,
Ron Watson

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 16 1999 - 09:21:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US