Hello,
The company where I work uses oracle forms 6i on Windows 8 and 7 for its users. They managed to configured it properly to run well on these S.O., also they are using OLE2 to generate Excel files... Everything working well but there are some random issues when generating Excel files, sometimes it crashes, others times doesn't generate Excel files well, other times it generates it well...
I know oracle forms is not supported to work with windows 8 and 7 and the company is migrating but it will take a while...
Meanwhile, what solutions could you guys propose??... Maybe a good solution could be downgrading theses "OLE2 drivers" on windows 8 to the ones used in windows xp? how could you do this?...
Thank you very much in advanced!.
Here some example of the code using OLE2:
Here some example of the code used:
PROCEDURE NEW_EXCEL (
PE_APPLICATION IN OUT OLE2.OBJ_TYPE,
PE_WORKBOOKS IN OUT OLE2.OBJ_TYPE,
PE_WORKBOOK IN OUT OLE2.OBJ_TYPE,
PE_WORKSHEETS IN OUT OLE2.OBJ_TYPE
)
IS
BEGIN
PE_APPLICATION := OLE2.CREATE_OBJ('EXCEL.APPLICATION');
PE_WORKBOOKS := OLE2.GET_OBJ_PROPERTY(PE_APPLICATION,'WORKBOOKS');
PE_WORKBOOK := OLE2.INVOKE_OBJ(PE_WORKBOOKS,'ADD');
PE_WORKSHEETS := OLE2.GET_OBJ_PROPERTY(PE_APPLICATION,'WORKSHEETS');
END;
--------------------------------------------------------------------------------------------------------------------------------
PROCEDURE OPEN_EXCEL (
PE_APPLICATION IN OUT OLE2.OBJ_TYPE,
PE_WORKBOOKS IN OUT OLE2.OBJ_TYPE,
PE_WORKBOOK IN OUT OLE2.OBJ_TYPE,
PE_WORKSHEETS IN OUT OLE2.OBJ_TYPE,
PE_NOMBRE_ARCHIVO IN VARCHAR2
)
IS
BEGIN
-- SE INSTANCIA LA APLICACION EXCEL Y SE DEJA VISIBLE --
PE_APPLICATION := OLE2.CREATE_OBJ('EXCEL.APPLICATION');
PE_WORKBOOKS := OLE2.GET_OBJ_PROPERTY(PE_APPLICATION,'WORKBOOKS');
ARGS := OLE2.CREATE_ARGLIST;
OLE2.ADD_ARG(ARGS,PE_NOMBRE_ARCHIVO);
PE_WORKBOOK := OLE2.GET_OBJ_PROPERTY(PE_WORKBOOKS,'OPEN',ARGS);
OLE2.DESTROY_ARGLIST(ARGS);
PE_WORKSHEETS := OLE2.GET_OBJ_PROPERTY(PE_WORKBOOK,'WORKSHEETS');
END;