Re: Connecting via Scripts

create a file (pw) with scott/tiger in it. Be sure to hit the carriage return before closing the file. chmod 600 pw

The runtime script would be

        sqlplus <pw _at_what_ever.sql

DAGMARA_at_DELPHI.COM (DAGMARA_at_news.delphi.com) wrote:
:> I am currently supporting a client who embeds their ORACLE accounts and
:> passwords within their UNIX scripts (for all the world to see). It's
:> been quite a while since I wrote cron jobs to connect to ORACLE using a
:> user account (my world is more or less isolated to SQL*DBA) and I can't
:> recall how to do this. Suggestions please! They are using HP-UX UNIX.
 

:> Dagmar Anne Bogan
 

:> Kopania & Komorovsky Specializing in Data Architecture
:> Richardson, TX 75081 and Performance Engineering
 

:> dagmara_at_delphi.com

--
This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.