ora-305500 occures when using ole
dear all
I inserted miscosoft excel sheet in an ole container in my block 'block1'. now i just want to write the word 'test on col1,cell1 . i did the following:
DECLARE
WORKSHEET OLE2.OBJ_TYPE;
CELL OLE2.OBJ_TYPE;
ARGS OLE2.LIST_TYPE;
BEGIN
FORMS_OLE.activate_SERVER('BLOCK1.EXCEL_SHEET');
WORKSHEET := FORMS_OLE.GET_INTERFACE_POINTER('BLOCK1.EXCEL_SHEET');
ARGS := OLE2.CREATE_ARGLIST;
OLE2.ADD_ARG(ARGS,1);
OLE2.ADD_ARG(ARGS,1);
CELL := OLE2.INVOKE_OBJ(WORKSHEET,'CellS',ARGS);
ole2.destroy_arglist(ARGS);
ole2.set_property(cell,'Value','test');
ole2.release_obj(cell);
ole2.release_obj(WORKSHEET);
end;
i get the error ORA-305500. and when i debug my code , i nitice that the error is raised on the line
CELL := OLE2.INVOKE_OBJ(WORKSHEET,'CellS',ARGS);
i do not know why
would any one give me a suggestion
thanks in adavance