> -----Original Message----- > From: Mark Martin [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 29, 2002 10:55 AM > To: [EMAIL PROTECTED] > Subject: DBI script won't run as cron job > > > I'm concious that this might be a Linux problem but maybe > someone on the > list has had the same issue and solved it. > > I copied out below one of the simplest functions from a perl > script that I > need to schedule every day. When I run it interactively the > table truncates > fine and I get all the print statements. However when I try > to run it as a > cron job nothing happens to the table and I only get the first print > statement in a log file - but the script compiles without > error and Oracle > doesn't feed back any errors either.
Oracle requires various environment variables to be set, and these are not set in your cron environment unless you explicitly set them. See perldoc DBD::Oracle for details on what needs to be set. -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
