-
Problems with SQL*Loader and Spatial objects...
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|