Home » RDBMS Server » Server Utilities » Re: Two challenges with the SQL*Loader tool
Re: Two challenges with the SQL*Loader tool [message #71423] Thu, 31 October 2002 06:26
Mark Grimshaw
Messages: 73
Registered: June 2002
Member
Mahesh,

In fact without trying the column object thing that you showed in your last email the problem still remains in the original form of my control file if the lengths of varchars matches (the error was in my email and not in the problem but well spotted anyway).

I am *STILL* left with original problem however and before I change all the VARRAY types in my database I need to know how you can load the data as stated in my first email - I think that it can't be done if I leave the Strings variable as a VARRAY OF VARCHAR2.

I cannot use the column object clause in the control file as I am not using an Oracle object type within a VARRAY collection type.

Mark
Previous Topic: Trying To Load Data WITHOUT Blanks.
Next Topic: Oracle view and external Data
Goto Forum:
  


Current Time: Mon May 13 18:45:47 CDT 2024