Ole container Helppp

From: Patrick Latour <patrick.latour_at_cia.ca>
Date: 2000/01/31
Message-ID: <vXml4.9619$gi.133051@news20.bellglobal.com>#1/1

I've tried everything and a can't make the ole container (containing a excel worksheet) works.

Everytime i try to get or set the value of a cell, i've always have the ora-305500 error !!!

heres the code i put in !!!

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', 'Hello Excel!');
 OLE2.RELEASE_OBJ(cell);
 OLE2.RELEASE_OBJ(worksheet);

END;
  please help me ! Received on Mon Jan 31 2000 - 00:00:00 CST