Modifying Attributes of an Embedded/Value Instance

If the object instance is retrieved using a dynaset object, it's attribute values can be modified between a Dynaset Edit/Update pair. The following example modifies the 'street' and 'city' attribute values of the ADDRESS object instance.

set OO4OSession = CreateObject("OracleInProcServer.XOraSession")

set hrDb = OO4OSession.OpenDatabase("HRDB", "scott/tiger", 0)

set Person = hrDb.CreateDynaset("select * from person", 0&)

set Address = Person.Fields("Addr").Value

Person.Edit

Address.Street = "Oracle Parkway"

Address.City = "Redwood shores"

Person.Update