Re: invoking SQL*PLUS

Glad it helped...in spite of my spelling adventures...

John Kachurick <jokach_at_epix.net> wrote:

>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 Thu Apr 05 2001 - 09:21:05 CDT