Problem to describe VARRAY type in ctl file for SQL*Loader
Hello,
My version of Oracle is 10.2, and I use SQL*Loader.
I created a Varray type :
CREATE Or Replace TYPE GroupVarray IS VARRAY(50) OF NUMBER(38,0)');
SQL*Loader doesn't work this data type because I don't know to describe this data type in the CTL file.
Can you help me to write the correct file ?
Thanks for your help.
My version of Oracle is 10.2, and I use SQL*Loader.
I created a Varray type :
CREATE Or Replace TYPE GroupVarray IS VARRAY(50) OF NUMBER(38,0)');
SQL*Loader doesn't work this data type because I don't know to describe this data type in the CTL file.
Can you help me to write the correct file ?
Thanks for your help.
0