SQL & PL/SQL

create table vehicle(engine_mot varchar2(3),indices number(3));

insert into vehicle values('K9K',1)

insert into vehicle values('K9K',2)

create type sub_ind as varray(100) of number(3);

based on this  type i am creating a table

create table vehicle_sub(engine_sub varchar2(10),mot_typ varchar2(3),eng_ind sub_ind);

above table is created so that mot_typ wil have more indices.

insert into vehicle_sub values('SFAM-01','K9K',sub_ind(1,2));

NOW my requirement  arises  to join these table and fetch the record...


  select engine_mot,indices
 from vehicle,vehicle_sub
  where vehicle.engine_mot=vehicle_sub.mot_typ
 and  vehicle.indices=vehicle_sub.eng_ind
and  vehicle.indices=vehicle_sub.eng_ind
ERROR at line 4:
ORA-00932: inconsistent datatypes: expected NUMBER got SEN.SUB_IND                     *