PHP-ORACLE Integration

2750035

i have created one php cript to run sqlldr from php script. If i am running from putty its running properly. but not running from browser. Its giving return code 3 but from putty i am getting 0.

script is to import csv from php into oracle database.

Christopher Jones-Oracle

A wild guess is that your Oracle environment variables aren't set correctly.  Create a shell script that sets them and calls sqlldr.  From PHP, call the shell script.

2750035

Hii Thanx for your reply.

Same thing is happening with shell script also.

script is running from putty using command sh /var/www/filename.sh

and php /var/www/filename.php

but same script is not running from browser.

I am using exec in this.

2750035

can you give me example OF SHELL SCRIPT because my enviromnet variables are set properly.??

Christopher Jones-Oracle

I think there's one in the Underground PHP & Oracle Manual, but yours might need to be different.

Triple check the environment and permissions let you do what you want to do.