i have a simple question. Can i call an external program from an PL/SQL procedure.
If yes. How can i make this. Can you give me a small example and which packages must be installed.
our system runs under linux with the oracle enterprice edition 8.1.7.
[Edited by tomate on 04-06-2001 at 02:14 AM]
running external programme
use HOST Command:
Built-in Type unrestricted procedure
Enter Query Mode yes
system_command_ string Specifies the system command you want to pass to your particular operating system.
screen_actio Specifies one of the following constants:
no parameter Specifies that Form Builder will:
n clear the screen
n prompt the operator to return from the command
NO_PROMPT Specifies that Form Builder will:
n clear the screen (does not prompt the operator to return from the command)
NO_SCREEN Specifies that Form Builder will:
n not clear the screen
n not prompt the operator to return from the system command
(The HOST command should not send output to the screen when using the NO_SCREEN parameter.)
Note: Thescreen_action parameter is only relevant to applications running in character mode, where the output of the Host command is displayed in the same window as the form. In GUI applications, the output of the Host command is displayed in a separate window.
Can You tell me how the procedure is named that i implement this procedure host into the database.
Do you want to call the PL/SQL Procedure from Oracle Application ?
If yes then,
go into the o/s and write the procedure in a file with .sql extension and then move the file to application specified directory under sql or you can even store the procedure as a stored procedure and call it in oracle application.
for doing so,
Navigate to Application Developer Responsibility and then enter in to Concurrent Program Menu and then into Create Executables form
in that if u are using stored procedure,
select the execution method as stored procedure and then tell the procedure to be called.
and then attach this executable file to Concurrent program. and then call the concurrent program as a report or process.
if you are aware about concurrent programs pls let me know so that I can proceed further.
Click Here to Expand Forum to Full Width