we used sqlldr in forms 6i using host command. Later we upgraded to forms 10g but now the host command is not working. we are able to create directory with the host command, but not able to invoke sqlldr, also forms 10g is not giving any error also, (forms status is success). Did anybody faced similar problem? Can anyone please help me regarding this..
When we faced this problem, we found that sqlloader was only available on our database tier (you could always install a database oracle home without an instance on your middle tier machine if you are on linux/unix).
We found some code from the database forum for something called xhost, which used a java call to create a version of host that started a session on the database tier. If you search for 'xhost' you should find it.
Thank you, but our environment is on windows NT and we have sqlldr on the previous iSuites/bin. Do you think, is it due to the older version or some path problem? Do we need to install a new client version?
forms 6i, 6iAS.
forms 10g, 10g AS.
Both old and new versions are on the same machine as we are doing the development.
Actually, sqlldr is on the application server and running fine with the 6i, as the respective control, data and log files were on the same machine. Now, we upgraded to forms 10g and trying to use the same sqlldr, but found that it is not being invoked at all.
We first suspected the host command, but we are able to create a directory as follows,
This is working fine. But not sqlldr... I searched on metalink if there are any links on the issue but able to find the same problem unanswered.
Yeah, when we tried it manually it is working fine. All the available home paths were selected and tried. Thought of installing a new 10g client so that I can get another sqlldr, but NT and 2000 versions does not support that version.
We tried to reinstall the client version into 10g AS home. Everything got corrupt. We removed the forms 6i home and installed 10g AS again and a 9i client on a different home. Now also I get the same problem. Even though I added the sqlldr path into various homes, I am getting the same error. :-(