gtzinos gtzinos - 1 year ago 55
MySQL Question

I can't create type object with variable type long on oracle database

I can't compile this code.
The long type not supported.

create type one_obj is object (art varchar(255),name varchar(255),surname varchar(255),number long,address varchar(255),team varchar(255));

create type one_tab is table of pelatis_obj;

what can I do to have a same type like long ?

Answer Source

Long is not supported in object types, please use CLOB.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download