?
Solved

Run a exe program in a form

Posted on 1998-11-16
4
Medium Priority
?
3,316 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 200 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

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…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

771 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