DDE
built-in packageThe DDE
built-in package provides Dynamic
Data Exchange (DDE) support within Reports Builder components.
Dynamic Data Exchange (DDE) is a mechanism by which applications can communicate and exchange data in Windows. DDE client support is added as a procedural extension to Reports Builder. The PL/SQL package for DDE support provides application developers with an Application Programming Interface (API) for accessing DDE functionality from within PL/SQL procedures and triggers.
The DDE functions enable Oracle applications to communicate with other DDE-compliant Windows applications (servers) in three ways:
DDE does not include the following:
data linking (advise transaction)
Oracle applications cannot automatically receive an update notice when a data item has changed.
Server support
Oracle applications cannot respond to commands or requests for data from a DDE client. Oracle Applications must initiate the DDE conversation (although data may still be transferred in either direction).
DDE
functions overviewAs part of the DDE
built-in package, the DDE
functions
available from within PL/SQL procedures and triggers can be grouped into the
following categories:
These functions are used to start and stop other DDE Server applications.
Begins a DDE server application. | |
Ends a DDE server application. | |
Focuses a DDE server application. |
These functions are used to connect to and disconnect from DDE server applications.
Starts a DDE conversation with a DDE server application. | |
Ends a DDE conversation with a DDE server application. |
These functions are used to exchange data with DDE server applications.
Executes a command recognized by a DDE server application. | |
Supplies information to a DDE server application. | |
Requests information from a DDE server application. |
These functions are used to translate DDE data type constants to strings and
back; in addition, DDE.GETFORMATNUM
allows users to register a new data format that is not predefined by Microsoft
Windows. Note that these functions do not translate the data itself (all DDE
data is represented with the CHAR
data type in PL/SQL), just data
type constants.
Convert/register a data format string to a number. | |
Convert a data format number to a string. |
Note: When you attempt to execute a Windows-specific built-in function on a non-Windows platform, the following messages are generated:
Trigger <name>
raised unhandled exception.
ORA-06509, 00000 PL/SQL: ICD vector missing for this package.
Microsoft Windows predefined data formats
Copyright © 1984, 2005, Oracle. All rights reserved.