Re: HELP: How do I run batch programs with Oracle

Hi Simon !

Try manipulating with spaces after the command. For eg.

   sqlplus "                                  
				$1/$2"

However, the ps implementation might be different on different hardware. But this atleast works on HP and Sun.

Hope this helps..
cheers

Mohan

si002_at_seqeb.gov.au (Simon Inglis) wrote:
>
>Greetings all,
> I have a simple problem. I need to run some Oracle unix software as
>part of a batch load of an Oracle datbase. To load the database I need to
>run SQL*LOADER. My problem is this: How can I run SQL*LOADER from a shell
>script (cshell) so that my username/password does not appear when an user
>does a "ps -ef"?
>
>My only solution so far is to pipe my username/password to the oracle
>tools. Eg for sqlplus:
>
>-----start of shell script----------
>echo "$MY_PASSWORD \
>$1 $2 $3 $4 $5" | sqlplus -s
>------end of shell script-----------
>
>Is there a more elegant solution?
>_________________________________________________________________________
>Simon Inglis
>bss_simoni_at_seqeb.gov.au
>singlis_at_gucis.cit.gu.edu.au
>_________________________________________________________________________
>
Received on Wed Dec 13 1995 - 00:00:00 CET