OraFAQ Forum: Forms » OLE2 issue in forms 11g

Home » Developer & Programmer » Forms » OLE2 issue in forms 11g (Forms 11gr2 windows 2008 64-bit)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

OLE2 issue in forms 11g [message #561271]

Fri, 20 July 2012 01:31

LAXMANJV
Messages: 1
Registered: July 2012
Location: bANGALORE

Junior Member

Hi All,

I am using the below code to read the Excel file(XLS). It is working fine in Forms 10g.We have migrated to 11G and file reading is not happeing and ora-305500 is coming.

APPLICATION := OLE2.CREATE_OBJ('Excel.Application');
OLE2.SET_PROPERTY(APPLICATION,'Visible','true');
WORKBOOKS := OLE2.GET_OBJ_PROPERTY(APPLICATION, 'Workbooks');
ARGS := OLE2.CREATE_ARGLIST;
OLE2.ADD_ARG(ARGS,P_FILE_NAME);
WORKBOOK := OLE2.GET_OBJ_PROPERTY(WORKBOOKS,'Open',ARGS); --Not able to execute
OLE2.DESTROY_ARGLIST(ARGS);
ARGS := OLE2.CREATE_ARGLIST;
OLE2.ADD_ARG(ARGS,1);
WORKSHEET := OLE2.GET_OBJ_PROPERTY(WORKBOOK,'Worksheets',ARGS);
OLE2.DESTROY_ARGLIST(ARGS);

Report message to a moderator

Previous Topic:	Forms 11GR2 image manipulation
Next Topic:	Oracle FORMS 6i to any web interface app

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 22:31:29 CDT 2024