My Oracle Support Banner

Attemtping to Access More Than 256 Columns or 65536 Lines in Excel Using CLIENT_OLE2 fails with WUO-709 (Doc ID 1073649.1)

Last updated on AUGUST 14, 2020

Applies to:

Oracle Forms - Version 10.1.2.3.0 and later
Information in this document applies to any platform.

Symptoms

A Forms application is used to process MS Excel Sheets using WEBUTIL.CLENT_OLE2.
Accessing the first 256 columns (A to IV) goes fine, but any attempt to access columns IW and beyond with code such as:

.../...
args:=Client_OLE2.create_arglist;
Client_OLE2.add_arg(args, 1);
Client_OLE2.add_arg(args, 'IW');
cell:=Client_OLE2.get_obj_property(worksheet, 'Cells', args);
.../...

fails with:

WUO[getProperty()] Value of WUO_OLE2_GET_OBJ_PROPERTY_ARGS=
ERROR>WUO-709 [OleFunctions.get_obj_property_args()] Unable to get Property: Cells; Exception
com.jacob.com.ComFailException: Invoke of: Cells
Source:
Description:

Note: A similar error occurs for lines beyond 65 536.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.