OWB - Invoking SQL*Loader from Process Flow
By David Allan on May 25, 2011
Quick post on how to execute SQL*Loader from within a process flow. You can use the SQL*Plus activity and invoke the sqlldr command via the SQL*Plus HOST command passing the specific parameters you want.
Below you see variables being used for the user and password, and the control file (to make more dynamic the entire script could have been a variable that was constructed);
The process flow must be configured to defined the deployed location which is the credential that is used for SQLPlus (that’s why I can use the variables (Target.User etc..). Below I just used SCOTT_LOCAL location for the example.
Also by default SQLPlus and all other external activities are disabled so you will have to enable this in the Runtime.properties file and stop/start the runtime service. Just now the file has an entry
property.RuntimePlatform.0.NativeExecution.SQLPlus.security_constraint = DISABLED
this needs changed to..
property.RuntimePlatform.0.NativeExecution.SQLPlus.security_constraint = NATIVE_JAVA
in order to execute the SQLPlus activity.