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);
|
|
|