Call shell script from php not run ?

raccsdl · #1 (**permalink**) 11-19-2007

Hi.

I write a shell script for import data to oracle using sql loader.

I set permission 755 or 777 for that script. I can run that script in the consol okay.

When I call it from PHP using system command. I got return value 126 this value when don't have permission right ?

I check step by step and dicover this line fail : /home/oracle/app/oracle/product/11.1.0/db_2/bin/sqlldr testing/testing@orcl control=$1 bad=$2 log=$3 discard=$4 data=$5 direct=TRUE.

Can anyone help me. this is urgent. Thanks so much.

Cameron · #2 (**permalink**) 11-19-2007

I suspect that you have to manage your environment variables from within your script.
Doing that should ease your pain.

Fella's, didn't the forum have a similar issue with a script returning "value 126" for someone else in the past month?

Cameron · #3 (**permalink**) 11-19-2007

Found it, not quite the same, though similar...

Cron - Not working properly

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
URL call from SHELL script	chengwei	Shell Programming and Scripting	37	04-15-2009 10:52 PM
To call/execute a shell script from a shell script	konark	UNIX for Dummies Questions & Answers	1	10-26-2007 06:16 PM
how can i call a shell script from pl/sql	rajesh.P	Shell Programming and Scripting	3	09-17-2007 12:09 AM
how can a call shell script from pl/sql	rajesh.P	UNIX for Dummies Questions & Answers	0	09-14-2007 03:42 AM
How to call a shell script from awk ?	Amruta Pitkar	Shell Programming and Scripting	1	04-20-2007 05:35 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by