Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
Database Developer Tools
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: May 3, 2012 4:29 AM by
Hot to use the data grid to edit column objects
May 3, 2012 4:29 AM
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
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?
This content has been marked as final.
Show 0 replies