opinion is an art !
-Original Message-From: Johan Muller
[mailto:[EMAIL PROTECTED]Sent: Thursday, October 16, 2003 2:09
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
SUPPRESS SQL STATEMENTS
I run the following script, and the -S option solved the problem I had (I
even had
I run the following script, and the -S option solved the problem I had (I even had the line # out in the script and re-invoked it).
If the username/pw is on a separate line as shown below, the ps command does not display the userid/pw info.
# Set environment variables#!/bin/ksh
# Set local env
ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: SUPPRESS SQL STATEMENTS
True, but last I checked it had a number of limitations... it's basically a band-aid, while the patient is hemorrhaging.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
True,
but last I checked it had a number of limitations... it's basically a
band-aid, while the patient is hemorrhaging.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Wednesday, October 15, 2003
2:09 PMTo: Multiple recipients of list ORACLE-LSubject:
s of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: SUPPRESS SQL STATEMENTS
On *nix systems, the username/password information will be visible to all via the "ps" command. Not good.
-Original Message-
Sent: Tuesday, October 14, 2003 11:
On *nix systems, the username/password information will be visible to all via the "ps"
command. Not good.
-Original Message-
Sent: Tuesday, October 14, 2003 11:09 AM
To: Multiple recipients of list ORACLE-L
Don't run the script while you're inside sqlplus. Run it from outside:
sqlplus
> -Original Message-
> Johan Muller
>
> A script dumps out table info. (sqlplus on aix 4.3.3 and
> oracle 8.1.7).
>
> I cannot suppress the PROMPT>@path/scriptname and
> PROMPT> spool off statements from the report output.
>
> The script contains both set heading off and set feedback
Use the silent option -S in sqlplus
-Original Message-
Sent: Tuesday, October 14, 2003 12:29 PM
To: Multiple recipients of list ORACLE-L
The script is run from a cron job with a ksh script calling the sql from
outside sqlplus.
I've solved the problem by using sed to cull the offensive
EMAIL PROTECTED]
To
Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc
Subject
RE: SUPPRESS SQL STATEMENTS
Don't run the script while you're inside sqlplus. Run it from outside:
sqlplus un/pw @your-script
-Original Message-
Sent: Monday, October 13, 2003 12:
The script is run from a cron job with a ksh script calling the sql from outside
sqlplus.
I've solved the problem by using sed to cull the offensive lines, but I should be able
to use
sqlplus formatting statements to give the correct results. I did include message off
(from a
previous email),
Don't run the script while you're inside sqlplus. Run it from outside:
sqlplus un/pw @your-script
-Original Message-
Sent: Monday, October 13, 2003 12:49 PM
To: Multiple recipients of list ORACLE-L
A script dumps out table info. (sqlplus on aix 4.3.3 and oracle 8.1.7).
I cannot suppress
set head off message off feedback off echo off
_
David Kurtz
Go-Faster Consultancy Ltd.
tel: +44 (0)7771 760660
fax: +44 (0)7092 348865
mailto:[EMAIL PROTECTED]
web: www.go-faster.co.uk
PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba
-Original Message-
Start the script from another script?
Johan Muller wrote:
A script dumps out table info. (sqlplus on aix 4.3.3 and oracle 8.1.7).
I cannot suppress the PROMPT>@path/scriptname and
PROMPT> spool off statements from the report output.
The script contains both set heading off and set feedback o
A script dumps out table info. (sqlplus on aix 4.3.3 and oracle 8.1.7).
I cannot suppress the PROMPT>@path/scriptname and
PROMPT> spool off statements from the report output.
The script contains both set heading off and set feedback off as part of the
formatting.
Posssible solutions?
--
Pl
14 matches
Mail list logo
