asked on

Execute external app from PL/SQL

I want to be able to launch an external application form PL/SQL, for example open notepad.exe from a command in PL/SQL. Is this possible.

Thanks,

tbcox

You need to explain more -- is this PL/SQL in Oracle Forms, or an anonymous PL/SQL block running in SQL*Plus, or a PL/SQL stored procedure in the database, or some other thing entirely?

-Tom

tuck

ASKER

These would be stored procedures, sorry about that.

urim

The only way to execute external app from stored proceures is when the stored procedure is written in C.
This features is availabe from Oracle8, tou can write stored procedure in C, and then you can run any program you want on the server itself!!!
When the host and the server are two different machines you can not execute external app from stored procedure that will run on your client.

Mark Geerlings

It is also possible in Oracle7 (at least in Unix and WindowsNT) to have PL\SQL execute a host command on the server.

I have used this so scheduled PL\SQL jobs could rename and/or delete a data file file after processing it with utl_file, but on the client, it seems like there would be easier ways to call an executable than by having PL\SQL do it.

tuck

ASKER

OK, I want to keep this open for more information , but will post the points to urim's,

So it would not be possible to launch an external app on the client, what about if you ran a sql script in SQL+ on the client, could this be done.

Thanks

ASKER CERTIFIED SOLUTION

tbcox

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

tuck

ASKER

That is exactly what I need,
urim i will post a question to you and give you points also as I investigated this and that would work for server side applications.

Thanks