Running Unix commands from Oracle apex application

Question

Is it possible to run commands on another Unix server from an Oracle apex application ? Oracle apex and Unix are on different machines .

If you deploy an API Rest into UNIX server, you can reach it calling the endpoints created. But you'll need appropriate permissions on UNIX. Don't forget to create an ACL (Access Control List) in your database. — Enrique Flores
– Enrique Flores, Commented May 25, 2020 at 19:19

Koen Lostrie · Accepted Answer · 2020-05-24 19:04:27Z

2

Apex is just a layer on top of the database.

From within the oracle database you can execute OS commands, so you could execute a script that connects from your database server over ssh.
or you could wrap your unix command in a cgi script and have it run of http. In pl/sql you could then invoke it via apex_web_service.make_rest_request

Make sure you check security

answered May 24, 2020 at 19:04

Koen Lostrie

19.5k2 gold badges16 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jim Macaulay · Accepted Answer · 2020-05-24 18:35:31Z

0

No you cannot. If your requirement is just to transfer the files, you can use ftp or sftp commands. But to perform unix operations, you cannot run in different machines

answered May 24, 2020 at 18:35

Jim Macaulay

5,2515 gold badges32 silver badges60 bronze badges

Collectives™ on Stack Overflow

Running Unix commands from Oracle apex application

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related