How to Run Shell Commands from Oracle Forms?

To run shell commands from Oracle Forms, use /bin/ directory as a source in the Linux or Unix environment. The following is the example:

Run Shell Command from Oracle Forms Example

Suppose you want to run mv command to move a file from one directory to another. Then use the host command as following:
host('/bin/mv /user01/myfiles/abc.txt /user01/oradocs/abctxt', no_screen);

If the file is too large, then it can take time to move from one folder to another, and in this case, Oracle Forms will be engaged until the command finish. So to run a command in the background put ampersand (&) in the end of the command. Below is the example:
host('/bin/mv /user01/myfiles/abc.txt /user01/oradocs/abctxt &', no_screen);
Execute Shell commands from Oracle Forms example.

Comments

Post a Comment

Popular posts from this blog

How To Write Query in Toad for Oracle?

Image
You can write queries using SQL Editor in Toad for Oracle. Follow these steps: Write Query in Toad for Oracle Open Toad and connect to the Oracle database. Then click on the menu Database > Editor . An SQL Editor window will open. Here you can write the SQL queries as you write in SQL*Plus. After completing the query press Ctrl+Enter or F9 to execute. You can also format the SQL query in the Editor by pressing the Shift+Ctrl+F key combination or by clicking on the menu Edit > Format Code . Below is an example of a formatted SQL query: SELECT EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID FROM hr.employees WHERE department_id = 90 AND manager_id = 100 ORDER BY employee_id;
Read more

How to Kill Session in Toad for Oracle?

Image
In this how-to guide, you will learn how to kill a session in Toad for Oracle. To kill the session in Toad follow these steps: In Toad for Oracle, connect to the database with the user having ALTER SYSTEM KILL SESSION privilege or DBA privilege. After connecting to the Oracle database, click on the menu Database > Monitor > Session Browser . The Session Browser window will open, then select the session and do the right click on it and choose Kill Sessions option from the shortcut menu as shown in the below image. The selected session will be killed immediately. See also: How to Write Query in Toad for Oracle?
Read more

How to Change Password in Toad for Oracle?

Image
In this how-to guide, you will learn how to change the password in Toad for Oracle. Examples are below to change the password for the current Oracle user and any other user. Steps to Change Password of Current User in Toad for Oracle In Toad for Oracle, connect to the database then click on the menu Session > Change Password . A dialog window open as shown in the below image. Specify the new password in the New Password field and re-type in the Verify Password field and click on the Execute button. Now the password will be changed for the current user. Steps to Change Password of Any Other User Using Toad for Oracle In Toad for Oracle, click on the menu Database > Schema Browser . The Schema Browser window will open. Then click on the User tab. In the User tab, select the user for which you want to change the password. Then do the right-click on that user and from the shortcut menu choose Alter . The Alter User window will open as shown below. Then specif
Read more