Please give me some advice on using dde in oracle form 4.5

Hi Every One
Could you please give me some advice on using dde in form4.5 if you are familiar with it .
I designed a form called test. There is only one block in this form, And there is
one button called "RUN" and one text item called "SHOW" in that block . In the
WHEN-BUTTON-PRESSED trigger of "RUN" I have the code on the bottom. Before I run this form I started microsoft word97. When run this form and push the buuton "RUN", I always get the exception of DDE.DMLERR_NO_CONV_
ESTABLISHED ( A client's attempt to establish a conversation has failed.The service or
topic name in a When DDE.INITIATE call may be in error.) But when I make the connection from a Microsoft EXCEL macro using the same DDE service name and topic name, It is successful. Your advice is very appreciated. Thank you in advance.

Jinshu Zhang

DECLARE
  ConvID PLS_INTEGER;
BEGIN
  ConvID := DDE.Initiate('winword','system'); exception
when DDE.DDE_APP_FAILURE then
:show:='An application program specified in a DDE.APP_BEGIN call could
not be started. ';
When DDE.DDE_APP_NOT_FOUND then
:show:='An application ID specified in a When DDE.APP_END or When
DDE.APP_FOCUS call does not correspond to an application that is currently running. ';
When DDE.DDE_FMT_NOT_FOUND then
:show:='A format number specified in a When DDE.GETFORMATSTR call is
not known. ';
When DDE.DDE_FMT_NOT_REG then
:show:='A format string specified in a When DDE.GETFORMATNUM call does
not correspond to a predefined format and could not be registered as a user-defined format. ';
when DDE.DDE_INIT_FAILED then
:show:='The application was unable to initialize DDE communications, which caused a call to the DDE layer to fail.'; when DDE.DDE_PARAM_ERR then
:show:= 'An invalid parameter, such as a NULL value, was passed to a DDE package routine.';

When DDE.DMLERR_BUSY then
:show:='A transaction failed because the server application was busy.';

When DDE.DMLERR_DATAACKTIMEOUT then
:show:='A request for a synchronous data transaction has timed out.';
--When DDE.DMLERR_EXECACK_TIMEOUT then
-- :show:='A request for a synchronous execute transaction has timed out.';
When DDE.DMLERR_INVALIDPARAMETER then
:show:='A parameter failed to be validated. Some of the possible
causes are as follows:';
-- The application used a data handle initialized with a different item-name handle or clipboard data format than that required by the transaction.

• The application used an invalid conversation identifier.
• More than one instance of the application used the same object.

When DDE.DMLERR_MEMORY_ERROR then
:show:='A memory allocation failed.';

When DDE.DMLERR_NO_CONV_ESTABLISHED then
:show:='A client''s attempt to establish a conversation has failed.'||
  'The service or topic name in a When DDE.INITIATE call may be in error.';
When DDE.DMLERR_NOTPROCESSED then
:show:='A transaction failed. The item name in a When DDE.POKE or When
DDE.REQUEST transaction may be in error.'; When DDE.DMLERR_POKEACKTIMEOUT then
:show:='A request for a synchronous When DDE.POKE transaction has timed
out.';
When DDE.DMLERR_POSTMSG_FAILED then
:show:='An internal call to the PostMessage function has failed. ';
When DDE.DMLERR_SERVER_DIED then
:show:='The server terminated before completing a transaction. ';
When DDE.DMLERR_SYS_ERROR then
:show:='An internal error has occurred in the DDE layer.';

END; Received on Tue Feb 16 1999 - 16:18:16 CST