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
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
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
]
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:09 AM
To: Multiple recipients of list ORACLE-L
Don't run the script
True,
but last I checked it had a number of limitations...it's basicallya
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:
:
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 PROTECTED]
Sent: Wednesday, October 15, 2003 2:09 PM
To: Multiple
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-
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
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),
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:49 PM
To: Multiple recipients of list ORACLE-L
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
-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
off as
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?
--
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
14 matches
Mail list logo