My Oracle Support Banner

Host Command To Create and Give Access to a File using Oracle Forms Fails with No Error (Doc ID 2564412.1)

Last updated on MAY 03, 2023

Applies to:

Oracle Forms - Version and later
Oracle Forms for OCI - Version and later
Information in this document applies to any platform.


A file is being generate using the HOST command in Oracle Forms. Owner of this file is the "ORACLE" user (owner of the installation and a member of DBA group) with following permission set (640):
Owner has read/write permission
Group: Read permission. Oracle is part of DBA group.
Other users have no permission.

Goal is that another user (who is not part of DBA group) will be able to download this file. To achieve this, once the file is generated, the same HOST command is used to change the permission of the file, so other users can also access the file. Below is the snippet of code to accomplish this task, wherein the variable ofn includes absolute path to the file.  


However, file permissions remain unchanged. Same command works as expected when executed in a terminal window.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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