Solved

Run a exe program in a form

Posted on 1998-11-16
4
3,291 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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 …
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to recover a database from a user managed backup

688 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