• 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
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!