Solved

Run a exe program in a form

Posted on 1998-11-16
4
3,211 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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
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.

815 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

10 Experts available now in Live!

Get 1:1 Help Now