• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Inconsistent datatypes

 
Shiv Sidhaarth
Ranch Hand
Posts: 119
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 119
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic