updating collection

From: Frederic Houbie <fh_at_ionicsoft.comNOSPAAAAM>
Date: Wed, 28 Apr 2004 16:10:27 +0200
Message-ID: <pan.2004.04.28.14.10.27.6049@ionicsoft.comNOSPAAAAM>

Hi,
I have this structure

CREATE OR REPLACE TYPE Slot AS OBJECT (

	Name VARCHAR2(255),
	SlotValue VARCHAR2(2048) 

);
CREATE OR REPLACE TYPE Slot_Array AS VARRAY(30) OF Slot;

CREATE OR REPLACE TYPE Ob AS OBJECT (

	ID integer,
	Slots Slot_Array
	);

how can I update a slotvalue if I have ID using an update statement ?

Thanks

Fred Received on Wed Apr 28 2004 - 09:10:27 CDT