command not found ...

[dave broome_2]

thanks, I'll take a look at it now.

[dave broome_2]

this is the Metalink document that I used to create my procedures.

[Massimo Bianchi]

Sorry :)

What about the suggestion, of suing absolutes path names ? It should do the trick.

They are standard on unix.... i do not remember if you already tried it.

Massimo

[dave broome_2]

what is meant by absolute path names?
if you mean use /usr/bin/cp instead of just cp then yep, I do that. If something else, what is it?

[Massimo Bianchi]

Was that,

/usr/bin/cp.

Massimo

[dave broome_2]

yep. Is that wrong?

[Graham Cameron_1]

Well I'm stumped. Works fine here.
Where does the "Not found" message come out - on your terminal or to a trace file? Is it coming from the java proc or SQL ?
-- Graham

[dave broome_2]

it's coming when I run the java proc from a SQL prompt. I am using the exec (o/s command); The java procedure returns a failed status and the output message from the procedure is cp or mv not found. The result is that the file on the server has not be moved or copied.

[Graham Cameron_1]

Do you get any ERR> output when it fails?
Does it let you do "ps -fuoracle" ?
Or just "ps" ?
Then at least you could see what shell you have.

[Graham Cameron_1]

Dave
Did you solve this or have you given up?

[dave broome_2]

it has been solved by writing different java scripts that use java commands to do a specific task rather than one that takes any O/S command. Thanks for your help.