0 Replies Latest reply: May 3, 2012 4:29 AM by 934742 RSS

    Hot to use the data grid to edit column objects

    934742
      I have a simple object type:

      CREATE OR REPLACE TYPE TIMESLICE AS OBJECT
      (
      SINCE TIMESTAMP (6),
      UNTIL TIMESTAMP (6)
      );

      And a simple table with one column containing objects of this type:

      CREATE TABLE TABLE1
      (
      COLUMN1 TIMESLICE
      );

      I can insert into the table:

      INSERT INTO SLICES VALUES (timeslice (NULL, NULL));

      But when I try to use the data grid and write there the same string "timeslice (NULL, NULL)" as value I get the following error during commit:

      One error saving changes to table "TABLE1":
      Row 1: ORA-06550: line 1, column 55:
      PL/SQL: ORA-00932: inconsistent datatypes: expected UDT got CHAR
      ORA-06550: line 1, column 7:
      PL/SQL: SQL Statement ignored

      The data grid interprets the value as characters instead of an expression.

      How do I have to enter the object in the data grid?