in reply to Changing shells within a perl script
should besystem("$oracle_home/bin/sqlldr $user_id/$user_pwd@$sid control=$oracle_base/scripts/sqlldr/$ctlfile errors=$errors log=$oracle_base/scripts/sqlldr/$logfile >/dev/null 2>&1");
The backslash in front of the @ is necessary to prevent interpolation errors (weird that -w isn't picking this up).system("$oracle_home/bin/sqlldr $user_id/$user_pwd\@$sid control=$oracle_base/scripts/sqlldr/$ctlfile errors=$errors log=$oracle_base/scripts/sqlldr/$logfile >/dev/null 2>&1");
update nor does 'use warnings' but 'use strict' will.
|
|---|