Re: Newbie question

Sandra, Doug,

Thank you both for your replies.

Regards,
Keith

--
---------------------ANTI SPAM -------------------
Please remove myteeth before replying
Doug Cowles <dcowles_at_i84.net> wrote in message
news:38b881e4.9072389_at_news.remarq.com...


> Another option is not to use cron but to use the dbms_job package to

> let Oracle schedule the activity..

>

>

> On Wed, 23 Feb 2000 13:11:15 GMT, Sandra Fraune <sandra_at_muenster.com>

> wrote:

>

> >Hi,

> >

> >if I understand you right, you will execute sqlplus-commands automated

> >by a unix-script, perhaps with the help of crontab.

> >

> >Okay, because the 'cron' do not enter the /etc/profile or .profile

> >you had to put the environment parameter on top of your script.

> >Now, to execute sqlplus in a shellscript enter:

> >

> >sqlplus /@{ORACLE_SID}<<-EOF

> >        #here you can enter your sql-statements#

> >

> >EOF

> >

> >If you will not connect as / you had to create an OPS$-account.

> >

> >May this help?

> >

> >Sandra Fraune

> >

> >

> >

> >

> >

> >

> >

> >

> >In article <8908r8$aub$1_at_tilde.csc.ti.com>,

> >  "Dave Hedgehog" <K.Ratcliff_at_myteethbtinternet.com> wrote:

> >> Hope somebody can help me out with this....

> >>

> >> We have a EDI package which uses an Oracle 8 database.

> >> I have been asked to write an PL/SQL stored procedure to access this

> >> database & extract some information

> >> for reporting purposes (possibly using UTL_FILE ?).

> >> I don't have a problem writing & executing any SQL through SQL*PLUS in

> >> windows but how would I go about

> >> executing the stored procedure in a live environment through a UNIX

> >> automated script ? Is this possible ?

> >> Thanks in advance for any help.

> >> Keith

> >>

> >> --

> >> ---------------------ANTI SPAM -------------------

> >> Please remove myteeth before replying

> >>

> >>

> >

> >

> >Sent via Deja.com http://www.deja.com/

> >Before you buy.

>