Calling Oracle Forms from Oracle Reports
Under Developer 6i on Windows, there exists a pl/sql librarywhich can be used to invoke excutables residing on the PC.
1) Modify the D2KWEXEC.PLL to change any references to the Forms built-in MESSAGE to the Reports built-in SRW.MESSAGE.
2) Choose the 'Attached Libraries' section for your report and select the 'Navigator/Create' menu option - this will cause the 'Attached Library' dialog to be displayed.
3) Use the 'Find' button to locate the library file (D2KWEXEC.PLL) and then attached it to the report using the 'Attach' button. A warning is displayed you that a hard coded path name is being used and gives the option of removing it. If the full path is removed, then the FORMS60_PATH variable will be used subsequently to locate the library. The directory in which the library is located must be part of FORMS60_PATH.
Then select the appropriate trigger from where Oracle Forms should be invokedfrom. In that trigger reproduce the following code:
function return boolean is
command_string VARCHAR2 (100);
BEGIN
command_string := 'c:\orant\bin\ifrun60.exe';
RETURN d2k_winexec.execute (command_string);
END;
Note: 'command_string' contains the full path of the Oracle Forms Runtime executable.
When the trigger fires, the Forms Runtime Executable is invoked automatically.

0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home