Home » Server Options » Spatial » ORA-29532 (Oracle 11g,11.1.0.6.0 and WINXP)
ORA-29532 [message #352569] Wed, 08 October 2008 07:08 Go to next message
anil_mk
Messages: 110
Registered: August 2006
Location: Bangalore, India
Senior Member

Hi All,

I tried to execute the below statement but got the error

SELECT
SDO_GCDR.GEOCODE_AS_GEOMETRY
(
'SPATIAL',
SDO_KEYWORDARRAY
(
'3746 CONNECTICUT AVE NW',
'WASHINGTON, DC 20008'
),
'US'
) geom
FROM DUAL
SDO_GCDR.GEOCODE_AS_GEOMETRY
*
ERROR at line 2:
ORA-29532: Java call terminated by uncaught Java exception: oracle.jdbc.driver.OracleSQLException: ORA-00942: table or view does not exist
ORA-06512: at "MDSYS.SDO_GCDR", line 679
ORA-06512: at "MDSYS.SDO_GCDR", line 722

And when i tried to execute the DBMS_JAVA.loadjava in SQLPLUS which thrown the same error as above(Find the attached screen shot) .

Please suggest me if anyone is having the idea about how to resolve above the problem.

Thanks,
Anil MK
  • Attachment: 2.GIF
    (Size: 20.89KB, Downloaded 297 times)
Re: ORA-29532 [message #356630 is a reply to message #352569] Fri, 31 October 2008 10:20 Go to previous message
SteveSerra
Messages: 5
Registered: October 2008
Location: Nashua, NH
Junior Member
Anil,


I checked address at eLocation and it did geocode. So it must be syntax or db. What data are you using? Did it come in Oracle Spatial geocoder format?

If you haven't already downloaded the new geocoder white paper,
http://www.oracle.com/technology/products/spatial/pdf/11g_collateral/spatial11g_geocoder_twp.pdf
it has some good examples.

Hope this helps,

thanks

Steve


Go verify address at http://elocation.oracle.com/elocation/ajax/
Previous Topic: Data for Spatial
Next Topic: ORA-29855
Goto Forum:
  


Current Time: Fri Jul 25 22:29:31 CDT 2014

Total time taken to generate the page: 0.09916 seconds