Skip to Main Content
Forums

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Webutil OLE2 in Forms 12

Alexis BAug 26 2020 — edited Aug 27 2020

Hi All

I am migrating an oracle forms 6i application to a forms 12.1.2.4 application

In forms 6i, I have the screen that generate an xml file

pastedImage_0.png

and display it in an OLE Object (Excel.Sheet.8) in a forms 6i screen

pastedImage_1.png

Is it possible to display an xml file with the same way in Forms 12c? Else I will open directly the XML file with Web.Show_Document, not a big problem i know do this.

BUT before this I have the problem to generate the XML file

In forms 6i Library OLE2 was used. I tried to replace OLE2 library with CLIENT_OLE2 package from library WEBUTIL

But when I execute it I got the following error message :

When trying to execute the following line :

application := CLIENT_OLE2.create_obj('Excel.Application');

I know that my Webutil is correctly configure as I can use the following webutil function withouth any error :

WEBUTIL_FILE.FILE_OPEN_DIALOG

Any Idea why this error occurs?

On my PC I have Microsoft Office Professionnel Plus 2016 installed

On the Application server Excel is not installed. Could it be the cause?

Thanks,

Best regards,
This post has been answered by Alexis B on Aug 27 2020
Jump to Answer

Comments

Processing

Post Details

Added on Aug 26 2020
#excel, #forms, #moved-from-devops
8 comments
2,347 views