I am executing job flow from the clover server and the execute graph is having oracle data writer component. There is no sqlldr utility installed in the clover server and I've pointed sqlldr utility from a remote server.
When I execute , job flow is throwing
Cannot run program "sftp://####:***@server ip address/opt/oracle/product/11.2.0.3/client/bin/sqlldr": error=2, No such file or directory
In the same job flow I can copy file from this remote server successfully.
Is it not possible to execute sqlldr from remote server?
Is there any class path variable to be set?
Is it mandatory to install sqlldr in clover server?
When I execute , job flow is throwing
Cannot run program "sftp://####:***@server ip address/opt/oracle/product/11.2.0.3/client/bin/sqlldr": error=2, No such file or directory
In the same job flow I can copy file from this remote server successfully.
Is it not possible to execute sqlldr from remote server?
Is there any class path variable to be set?
Is it mandatory to install sqlldr in clover server?
-
Hi,
In case you want to use OracleDataWriter, the Sqlldr utility has to be installed locally on the same machine. You cannot use sftp in this case. For more information on OracleDataWriter please refer to our documentation. In case you cannot access the Sqlldr utility locally, you can still use DBOutputTable, which doesn't use native client, instead of OracleDataWriter.
Please sign in to leave a comment.
Comments 1