Inconsistent datatypes

[Shiv Sidhaarth]

Hi,
I am getting error when i tried to enter data into a column object. It
says "Inconsistent datatypes". Can u help me out?
-----------------------------------------------------------------
insert into perfscedesign
values('test',Components_Type(1,2,3,'test1'),4,5,6,7,8,9,null,null,Result_ty
pes(null,null))
*
ERROR at line 1:
ORA-00932: inconsistent datatypes.
-----------------------------------------------------------------
Thanks,
Sankar

[sundari swamy]

Originally posted by sankar sv:
Hi,
I am getting error when i tried to enter data into a column object. It
says "Inconsistent datatypes". Can u help me out?

post the structure of objects you have. What datatype are these elements

[Shiv Sidhaarth]

insert into perfscedesign values
('test',components(components_type(1,2,3,'comp1'),components_type(10,4,30,'c
omp2')),4,5,6,7,8,9,null,null,null)
The above code worked. I created nested table. Sorry for asking incomplete question. I didnt realise that the problem was there outside. Neway, thanks sundari, for ur time and reply.
Sankar