Run Sqlldr from PHP exec - Command Not Found Error '127'

691263

Hello,

I am trying to run the sqlldr command from PHP, but I get an status of '127' (Command not found). What am I doing wrong?

<?php

shell_exec("ORACLE_HOME=/opt/nasapps/proprietary/oracle/product/current; export ORACLE_HOME");
$setpath = "PATH=$" . "ORACLE_HOME/bin:$" . "PATH; export PATH";
shell_exec($setpath);
$command = "sqlldr username/[email protected]/sid control=test_control.ctl > /dev/null; echo $?";
$xx = exec($command);
echo trim($xx); #outputs 127

?>

Thank you,
S

Christopher Jones-Oracle

$ php54 -r "shell_exec('export MYTEST=something'); exec('env | grep MYTEST > /tmp/L.env');"
$ cat /tmp/L.env
$

The environment isn't set as you expect.

Try creating a shell script that sets the environment and runs the command, then call that script from PHP.