Hi,
I'm trying to load a number of oracle tables as a virtual tables. These
tables contain complex datatypes within certain columns.

Eg -
CREATE or REPLACE TYPE "CUST_ADDRESS_TYP"
as object
(streed_address varhar2(40),
postal_code varchar2(10),
city varhar2(30),
state_province varchar2(10),
country_id char(2)
);

or
create or replace type "phone_list_type" as varray(5) OF varchar2(25);


When trying to load these tables I get the error -
OE.CUSTOMERS   HY000   VD052: Remote DSN ORACLE_OE: [Easysoft][Oracle]Unable
to map datatype( 108 ) for column ( 4 )

Is there a way to either -

   1. Map these objects directly into objects within virtuoso
   2. Map these objects by exploding them into standard data types within
   virtuoso
   3. Simply exclude these columns from the table import

None of these options seemed to be available within conductor.

Cheers
Mark

Reply via email to