I am getting this error while retrieving data from the table on live SQL oracle
create or replace type infrastructure as object (
infra_id number,
typee varchar2(4000),
hours_needed varchar2(4000),
light varchar2(4000),
sound varchar2(4000)
);
/
create table arena_workers (
arena_id number,
infrastructure REF infrastructure
);
/
create table infrastructure_t of infrastructure;
/
INSERT INTO infrastructure_t VALUES(infrastructure(12,'sport', '70', 'Riga','disco'));
INSERT INTO arena_workers VALUES(12,NULL);
select * from arena_workers;
select * from arena_workers;
Response
Type created.
Table created.
Table created.
1 row(s) inserted.
1 row(s) inserted.
ORA-00932: inconsistent datatypes: expected CHAR got REF SQL_KBTPSVCAUGEFPBGBNCMXYJKRR.INFRASTRUCTURE
ORA-00932: inconsistent datatypes: expected CHAR got REF SQL_KBTPSVCAUGEFPBGBNCMXYJKRR.INFRASTRUCTURE