Re: Executing a script from Unix shell

From: <gmei_at_my-deja.com>
Date: Mon, 02 Oct 2000 18:28:23 GMT
Message-ID: <8rak3t$128$1@nnrp1.deja.com>

create a file called "callmyscript.sh":

#! /bin/sh

. /etc/profile
. /unix_user's_default_login_directory/.profile

sqlplus username/password_at_sid @myscript.sql

save the file. then you can run callmyscript.sh manually. If you want that run automatically, you can use cron job in unix to do that.

Hope this helps.

Guang

In article <8raa01$nm1$1_at_nnrp1.deja.com>, jpebejer_at_maltanet.net wrote:
>
>
> I have a script (myscript.sql) which I want to run AUTOMATICALLY each
> time from the shell through some sort of scripting (on a UNIX box).
>
> Aren't there some command line parameters to do this ?
> Say SQL*Plus myscript.sql ?
>
> Many Thanks
> JP
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Oct 02 2000 - 13:28:23 CDT