Oracle Forms

Hi,

I have a problem with invoking sqlldr from Forms10 using host command in
Unix environment(Solaris). I have two ORACLE_HOME's , one for IDS10g and second where is Oracle Client with sqlldr, which I have to invoke.
I have a script:


#!/bin/sh
NLS_NUMERIC_CHARACTERS=., ;export NLS_NUMERIC_CHARACTERS
ORACLE_HOME=/export/home/oracle/oracle/product/10.2.0/client_3
export ORACLE_HOME
echo $ORACLE_HOME > env1.txt
LD_LIBRARY_PATH=/export/home/oracle/oracle/product/10.2.0/lib32
export LD_LIBRARY_PATH
sqlldr TEST/TEST@orcl control='UOFE050.ctl' log='UOFE050.log' errors=1000000 skip=1
ORACLE_HOME=/u01/app/oaspers/frs; export ORACLE_HOME
echo $ORACLE_HOME > env2.txt


I have all neccesary paths in my default.env file (/usr/bin:/export/home/oracle/oracle/product/10.2.0/client_3/bin:
/usr/bin:/export/home/oracle/oracle/product/10.2.0/client_3) for FormsServer. I have tried invoke sqlldr with full path
and I have tried to change LD_LIBRARY for current ORACLE_HOME (in shell script). Of course from command line the script is working.
I know that only the line with sqlldr is not executed, so I have found a couple of threads on this forums but i have not found solution
for my issue - with two ORACLE_HOME's - the invocation of script in Forms is - host('scr.sh').

I am using webutil for uploading file to AS, and I do not want to use sqlldr on client.

ps. the experiment for Windows was OK - with Host('cmd /k scr.bat',no_screen);


thanks for help,
gregory