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:
<cfexecute name="sqlldr" arguments="DEMO@DEMO/pwd2011 control=/opt/coldfusion8/runtime/bin/my_ControlFile.ctl" timeout="500"></cfexecute>
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?
