I'm trying to load some data which contains one rectangle per row into a table using SQL*Loader and Oracle 9i.
The first time I ever looked at SQL*Loader was this morning, so I expect my problem is just that I don't know what I'm doing, anyhow ....

...the relevent bit of my control file is...

.
.
.
STREET_CLOSURE_DATE date "yyyymmdd" terminated by "," nullif STREET_CLOSURE_DATE="0",
GEOLOC column object (
SDO_GTYPE constant 2003,
SDO_ELEM_INFO varray count(constant 3) (
<< what do I put in here? I need to set SDO_ELEM_INFO to (1,1003,3) >>
),
SDO_ORDINATES varray count(constant 4) (
element integer external terminated by ":"
)
),
TOLERANCE integer external terminated by ",",
.
.
.

All the rest of it works fine but I can't figure out how to set the SDO_ELEM_INFO field to the required value of (1,1003,3). I I read the values from the data as I do for the SDO_ORDINATES fields its easy, but I just want to specify constant values here instead.

Any help most welcome.