Re: HELP! Running SQLPlus in batch

Hi Mark,

If you have OPS$ accounts and the database and script are on the same server you can use this in your shell:

        sqlplus -s / @$PATH_SRC/xxx.sql

In a CRON job you will have to give the entire PATH rather than $PATH_SRC.

For SQL*Plus code fragments, you can also do this in a Unix HERE document if you wish:

sqlplus / << HERE
SET PAUSE OFF FEEDBACK OFF
UPDATE TABLE1 SET SEQCODE = 1 WHERE SEQCODE = 0 /
COMMIT;
exit
HERE Suresh
www.oracleguru.net
oracleguru_at_mailcity.com

Mark Kimball <mkimball_at_rhs.org> wrote in article <P1wJ2.2$Ja4.130113_at_IConNet>...
> 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 Tue Mar 23 1999 - 11:46:57 CST