Re: HELP! Running SQLPlus in batch

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 22 Mar 1999 20:58:00 +0100
Message-ID: <36F6A0C7.E9F6B86F@sybrandb.demon.nl>

Hi Mark,
The only problem there should be hardcoded username passwords in shell scripts.
The only precaution: Make sure . oraenv runs somehow before sqlplus is started

two methods:
sqlplus -s username/password_at_database @<name of plus script> or
sqlplus -s username/password_at_database <<EOD ....
EOD
Note: piping and filtering works as expected.

Hth,

Sybrand Bakker, Oracle DBA

Mark Kimball wrote:

> I'm trying to run SQLPlus code in batch mode in HP-UX. Any suggestions on
> how to make this happen? Running Oracle 7.3.2 on HP9000 with Unix 10.20.

Received on Mon Mar 22 1999 - 13:58:00 CST