This error message is usually produced when your ORA_NLS33 is not set, or set incorrectly. As it is being run from cron, there will be no environment at all!
Make sure your perl script sets the various %ENV values before executing the backticks. Andrew -----Original Message----- From: Strohmeier Ruediger [mailto:[EMAIL PROTECTED] Sent: 11 August 2003 10:15 To: '[EMAIL PROTECTED]' Subject: [Perl-unix-users] Launching sqlplus from perl from crontab Hi, I am facing a problem with a script that includes a print LOG `/opt/oracle/product/V8i/bin/sqlplus -s id/pw <<END select count(*) from LOG where TIME \ like '$DAY$MONTH$YEAR $HOUR:%'; quit END`; It works fine when started from the command line. Using crontab however leads to an error: Message file sp1<lang>.msb not found Error 6 initializing SQL*Plus The file is of course available but apparently some environment is missing. Any ideas? Thanks in advance Ruediger _______________________________________________ Perl-Unix-Users mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs This message is for the named person's use only. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. CREDIT SUISSE GROUP and each legal entity in the CREDIT SUISSE FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT SUISSE FIRST BOSTON reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal written confirmation. _______________________________________________ Perl-Unix-Users mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
