View Single Post

   
  #1 (permalink)  
Old 02-23-2008, 10:08 AM
Frederic Houbie
 
Posts: n/a
Default updating collection

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
Reply With Quote