Maybe some more detail would be helpful:
if my table is this:
CREATE TABLE GEOMETRY_TEST
(
GID INTEGER,
G1 SDE.ST_GEOMETRY
)
And my sql loader ctl script is this:
LOAD DATA
INFILE *
TRUNCATE
INTO TABLE geometry_test
FIELDS TERMINATED BY '|'
OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS (
gid,
G1 EXPRESSION "sde.st_geomfromtext(':g1',0)"
)
BEGINDATA
1|"POINT ( 10.02000000 20.01000000),0"
2|"POINT ( 11.02000000 20.01000000),0"
Then I'm getting this back in my .log file:
Record 1: Rejected - Error on table GEOMETRY_TEST, column G1.
ORA-20003: Geometry type "" is not a valid shape type.
ORA-06512: at "SDE.ST_GEOM_UTIL", line 213
ORA-06512: at "SDE.ST_GEOMFROMTEXT", line 20
I've tried all kind of permutations but sofar without any luck,
regards,