Name of the user that owns the tables containing the geocoding data.I don't think your geocoding data is stored in MDSYS. If it is, I would strongly suggest to move it out of MDSYS (you should not need to put stuff in there, it's there for Oracle) and into a schema of your own. But you should enter the username/schemaname which owns the table your data is in.
Stefan Jager wrote:I only see your query, and no error. Or did you use the java interface again? By executing it through SQL Plus, we can eliminate this problem being caused by something in your java-environment, that's what I'd try to do (eliminate as many variables as possible, thus narrowing where to search for the problem).
execute the same query in SQL Plus (and not through a java interface), and show the command en results here
Rakesh wrote:Yes it does. Why don't you start with the [url http://docs.oracle.com/cd/E11882_01/appdev.112/e11830/sdo_geocode_concepts.htm#CIHECECC]documentation? Sections 11.5 and 11.6 in particular describe what to set up and how. Since you are using Java, [url http://download.oracle.com/otndocs/products/spatial/pdf/spatial11gr2_geocoder_twp.pdf]this whitepaper is also a very good place to start since it describes how to set up the J2EE Geocoder stuff.
The only table i see is "GC_COUNTRY_PROFILE".
Do you think this has any relation to the error?
Now look at a US address:
<streetname> <housenumber> <postal code> <city>
Even though these are two fairly similar countries in this respect, for machines to read this can be really confusing. So you need to tell them exactly what to expect and where to expect it, and that usually takes some setting up.
<housenumber> <streetname> <streettype> <city>, <State Abbreviation> <postal code>