From: TurkBear Newsgroups: comp.databases.oracle.misc Subject: Re: invoking SQL*PLUS Date: Wed, 04 Apr 2001 14:59:01 -0500 Reply-To: See Message body for real address Message-ID: References: <3ACB6F2B.8060805@epix.net> X-Newsreader: Forte Agent 1.8/32.548 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 26 X-Authenticated-User: 6fd2d0c3 X-Comments: This message was posted through Spamkiller.Newsfeeds.com X-Comments2: IMPORTANT: Newsfeeds.com does not condone, nor support, spam or any illegal or copyrighted postings. X-Comments3: IMPORTANT: Under NO circumstances will postings containing illegal or copyrighted material through this service be tolerated!! X-Report: Please report illegal or inappropriate use to You may also use our online abuse reporting from: http://www.newsfeeds.com/abuseform.htm X-Abuse-Info: Please be sure to forward a copy of ALL headers, INCLUDING the body (DO NOT SEND ATTACHMENTS) Organization: Newsfeeds.com http://www.newsfeeds.com 73,000+ UNCENSORED Newsgroups. 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 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.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? > >