| call an exe file from a DB Procedure [message #87567] |
Sun, 16 January 2005 21:58  |
fanni
Messages: 96
Registered: March 2004
|
Member |
|
|
I need to call an exe file from a DB Procedure.
I am using Oracle 9, Forms 6. Host Command Does not Work there .
1create or replace procedure proc3
2is
3begin
4 host('calc');
6* end;
SQL> /
Warning: Procedure created with compilation errors.
SQL> show errors;
Errors for PROCEDURE PROC3:
LINE/COL ERROR
-------- -------------------------------------------------------------
4/1 PLS-00201: identifier 'HOST' must be declared
4/1 PL/SQL: Statement ignored
|
|
|
|
|
|
| Re: call an exe file from a DB Procedure [message #87584 is a reply to message #87567] |
Mon, 17 January 2005 23:10  |
Himanshu
Messages: 457
Registered: December 2001
|
Senior Member |
|
|
Hi,
You cannot use Host command in backend pl/sql procs.
Create Java based procedures using loadjava to call any OS command.
Else if you are using an application server then you may keep the required command in a bat file & call the bat file from your procedure using utl_http.request.
HTH
Regards
Himanshu
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
