Oracle Forms (MOSC)

MOSC Banner

OLE2 command not working for Excel 2010

edited May 4, 2017 5:29AM in Oracle Forms (MOSC) 4 comments
Dear all,

I have some OLE2 commands through which I open a csv file in excel from Oracle Forms 6i and import the data from this csv file to the oracle database.  Until now, the user machines had Word 2003 and everything was working fine.  Very recently, we upgraded Word to 2010.  Thereafter, I am facing problem in importing the data from this csv file.  I reproduce the commands here:

*

DECLARE

workbooks OLE2.OBJ_TYPE;
 workbook OLE2.OBJ_TYPE;
 worksheet OLE2.OBJ_TYPE;
args OLE2.LIST_TYPE;
application OLE2.OBJ_TYPE;

BEGIN

application:= ole2.create_obj('Excel.Application');
--
workbooks := ole2.get_obj_property(application, 'Workbooks');

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center