2 Replies Latest reply: Mar 1, 2010 6:00 AM by 737673 RSS

    Updating a object subclass

    737673
      I am new to Object Relational databases and I am just experimenting. Im trying to update a object table but i want to update subclass attributes. I can update a object table with the following code with no problems
      UPDATE table_objtab p 
      SET p.col1 = 'updated value'
      WHERE p.col1 = 'current value;
      I cant however update the attributes that are in the subclass. Can any one help me?

      Im sorry if i have not provided enough information, if you require the object type and subclass type us ask =) any help would be appreciated.

      Thanks in Advance,
      -Ben