what’s the best way to ensure the ODI Agent picks up the environment settings required by SQLLDR wit

Sorry, a bit long.

Background

We have an ODI 11.1.1.7 EE Agent running on WLS on a Linux 2.6. distro (uname –a: 32-358.el6.x86_64 #1 SMP Tue Jan 29 11:47:41 EST 2013 x86_64 x86_64 x86_64 GNU/Linux).We also have an Oracle client installation on the same box which includes the SQLLDR utility. When trying to invoke SQLLDR through an ODI interface with an ODI LKM File to Oracle (SQLLDR) Knowledge Module that generates the following code:

 import java.lang.String

import java.lang.Runtime as Runtime

from jarray import array

import java.io.File

import os

import re

 

ctlfile = r"""/var/odi/itools/SRC_ITL_CALENDAR.ctl"""