This content has been marked as final. Show 2 replies
It is unlikely that a db upgrade has anything to do with your issue. As for why it may have worked before and not now... well I cannot answer that.
Generally, I like to describe how HOST works like this. The HOST built-in provides a way to execute OS commands from Forms through a shell (or DOS for Windows). However, it should be assumed that the shell being spawned is bare. Meaning that most or all of the system variables are not included. This means that even most of the simple/common commands will fail. I often recommend that you do not call a command directly. Instead, wrap in a script so that you take control over exactly how it should run. Try something simple. For example create a simple script which first sets the important variables like PATH, LD_LIBRARY_PATH, etc. Then try copying a file from place to place (e.g. cp foo.txt foobar.txt). From Forms, use HOST to call the script.
Also, here are two things to consider:
1. The installation owner must be the user that starts the instance
2. Be sure, in my example, that the file you create was created while logged in as the installation owner.
Solution for those interested and for anyone else searching this forum for a solution
I found this on My Oracle Support:
<h3>Host Command from Forms Not Working in 11g in Sun Solaris Sparc OS [ID 1157346.1]</h3>
Applies To: Oracle Forms - Version 184.108.40.206.0 and later
Sun SPARC Sun OS
When trying to execute a Shell script or any OS command using the host() Built-in from Forms 11g, the host()command is not getting executed. The same functionality works on other operating systems and in previous versions like 10gR2.
Steps to be followed:
1) Take a backup and edit the $DOMAIN_HOME/config/fmwconfig/servers/WLS_FORMS/applications/formsapp_11.1.1/config/default.env or any custom environment file.
2) Locate the following environment variable:
3) Comment out this variable. After the changes, it will look like the following:
3) a) Instead of LD_PRELOAD, kindly use LD_PRELOAD_64 as given below :
(This makes HOST AND RUN_REPORT_OBJECT work fine).
4) Save the file and execute your forms. The Host() built-in will work as expected
The LD_PRELOAD setting in default.env is only required for the working of signal chaining facility in JVM version 1.5 and later. If you are not using theSignal chaining facility, this variable is not required. For more information, refer to the following documentation