FORMS_SUCCESS Always True Even If Command Passed to HOST Built-In Returns Error (Doc ID 292074.1)

Last updated on OCTOBER 09, 2023

Applies to:

Symptoms

Forms application passes an o/s command to the HOST built-in, for example:

HOST('COPY "c:\temp\test.txt" "c:\temp\test.txt"',NO_SCREEN);
IF NOT FORM_SUCCESS THEN
message('Host command has failed');
RAISE form_trigger_failure;
END IF;

If the file c:\temp\test.txt does not exist, MS Windows raises an error
e.g.

"The system cannot find the file specified"

As a result FORMS_SUCCESS should also return false. Instead FORMS_SUCCESS actually returns true.

The problem reproduces at will on MS Windows versions 2000, XP, and 2003
The problem does not reproduce on MS Windows 95, 98 and NT

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.