Solved

Run a exe program in a form

Posted on 1998-11-16
4
3,159 Views
Last Modified: 2008-02-20
Hi !

If a  menu bar is activated in an Oracle form  version 4.5.7.1.6 I would like an .exe program to run in an own process.
I am working in NT4.0.
I start the program with host(system_command_string);
but you have to close the program to get back to the form.
I would like it to run at the same time.
Is it possible ?

0
Comment
Question by:annkal
  • 2
4 Comments
 

Accepted Solution

by:
jpotts earned 100 total points
ID: 1082566
The host command is more for running a command.
Use the DDE Package to run a concurrent application:

DECLARE
   AppID PLS_INTEGER;
BEGIN
   AppID := DDE.App_Begin('C:Prog.exe',DDE.APP_MODE_NORMAL);
END;

You can also use functions like DDE.App_End to end the app.
See Online Help for more details.
0
 

Author Comment

by:annkal
ID: 1082567
Hi !
I have done exactly like you but I ' get an answer
FRM -21011:PL/SQL unhandled exception ORA -106500.
I have the packages att the botton on my 'forms tree'
as built in Packages, but I' cant use it. Why?
0
 
LVL 3

Expert Comment

by:vlad_impala
ID: 1082568
The ORA-106500 message means that it cannot find the program you have told it to start.  Make sure you either use the full path, or that the program exists in a directory that is listed in you DOS path.

for example
AppID := DDE.App_Begin('c:\windows\notepad.exe',DDE.APP_MODE_NORMAL);
AppID := DDE.App_Begin('notepad.exe',DDE.APP_MODE_NORMAL);
would both work OK but
AppID := DDE.App_Begin('c:\notepad.exe',DDE.APP_MODE_NORMAL);
gives the ORA-106500 error.

Vlad
0
 

Author Comment

by:annkal
ID: 1082569
It works BUT I can't open the aplication with argument.
If I try from the command prompt:
c:\temp\Ides.exe -username my_user -password my_user connect_string mydatabas

it works but if I try that in the formprocedure

App.ID:=DDE.APP_BEGIN('c:\temp\Ides.exe -username my_user -password my_user connect_string mydatabas',DDE.APP_MODE_NORMAL);

it doesen't work. Does the package function add any garbage sign .
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Space Delimited Sql File 4 70
oracle query 15 63
File generation using utl_file 4 28
report returning null 21 50
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now