Spatial (MOSC)

MOSC Banner

spatial data and sqlldr

edited Apr 6, 2013 5:33AM in Spatial (MOSC) 8 commentsAnswered ✓
Hello,If this is the wrong place to ask this question, please let me know.  Also, if I posted this twice, I am sorry.  I am learning the community page, too.
P { margin-bottom: 0.08in; }

I am new to spatial data.  I am trying to use sql loader to load spatial data.  The nonpoint data is giving an error.  The log file indicates the error below:

Record 1: Rejected - Error on table RW_MAIN, column OGC_GEOMETRY.SDO_ELEM_INFO.E.

error converting data
ORA-01722: invalid number


Would anyone have a suggestion on what to look for to determine the problem and solution?  I will attach the control file, a .dat file with a few records, and the create table script.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center