SET VERIFY OFF
watsonr4_at_my-deja.com wrote:
>
> 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 - 10:12:09 CST
