cfexecute and sqlldr problem

Question

I use cfexecute to run sqlldr in windows seccessfully. I use the same technique to do it in unix and it failed. Have debugged the problem for almost one week with no result

Oracle client has been installed on the server, path to the control file, source file have been checked and all are good but once cfexecute is run, the error pop up. I don't know what else to do

Found similar problem on the web, followed it and still did not work:

http://www.justskins.com/forums/cfexecute-and-sqlldr-run-56805.html

Here is the only code to run sqlldr that's been giving me a headache:

Here is the error I got:

The following information is meant for the website developer for debugging purposes. Error Occurred While Processing Request

An exception occurred when invoking an external process.
The cause of this exception was that: java.io.IOException: Cannot run program "sqlldr": error=2, No such file or directory.


30 : <CFFUNCTION name="RunSQLLDR"> 31 : 32 : <cfexecute name="sqlldr" arguments="DEMO@DEMO/pwd2011 control=/opt/coldfusion8/runtime/bin/my_ControlFile.ctl" timeout="500"></cfexecute> 33 : 34 : </CFFUNCTION>

Can anyone who have successfully use cfexecute for running sql loader on Oracle 11 help me?

Owainnorth · Accepted Answer

Just tried to run it from command prompt and the records were inserted into the table but not through CFexecute both are using the same command prompt

Okay, try instead calling the sqlldr from a bash script, which puts the std output to a file, then call that instead. You'll then be able to see any commandline errors it throws.

Owainnorth · Answer

Use the full path to sqlloader, the error message clearly says it can't find it.

An exception occurred when invoking an external process.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded