Re: invoking SQL*PLUS

From: John Kachurick <jokach_at_epix.net>
Date: Wed, 04 Apr 2001 20:27:56 GMT
Message-ID: <3ACB83C6.4090708@epix.net>

I failed to add the Oracle_home to the script, now that I added it, it works perfectly ...

Thanks for your help!!!!

TurkBear wrote:

> In addition to all the path statements , be sure that the environment variables
> regarding Oracle_Home, etc are 'known' to the cron job...The message you
> received usually indicate an inability to fine Oracle_Home( under which  the
> *.msb files are)
> 
> John Kachurick <jokach_at_epix.net> wrote:
> 

>> Hi-
>>
>> I'm having a problem trying to invoke SQL*Plus through a cronjob on
>> HP-UX (and Oracle 7.3.4).
>> Here's what I'm trying to do:
>> I am trying to pass parameters to the PL/SQL statement through a shell
>> script. It all works fine when I run it from the operating system
>> command line, but when run as a cron job, it gives me the following error:
>>
>> Message file sp1<lang>.msb not found.
>> Error initializing SQL*Plus
>>
>> I made sure to put the correct path statements and all into the script
>> thats invoking the sqlplus command, but it still won't work
>>
>> What am I doing wrong?
>>
>>
Received on Wed Apr 04 2001 - 15:27:56 CDT