Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> missing class

missing class

From: Gregory Faktor <gfaktor_at_ecal.com>
Date: Tue, 5 Sep 2000 15:13:15 -0400
Message-Id: <10610.116238@fatcity.com>


Hi All!
I run following statement and get error. My question is how I can check if missing class in database or not?
Thanks.

SQL> SET SERVEROUTPUT ON
SQL> CALL DBMS_JAVA.SET_OUTPUT(6000); Call completed.

SQL> DECLARE
  2 in_addr MDSYS.GEOCODE_RECORD_TYPE := MDSYS.GEOCODE_RECORD_TYPE(null, nu;
  3 out_addr MDSYS.GEOCODE_RECORD_ARRAY_TYPE := MDSYS.GEOCODE_RECORD_ARRAY_;
  4 meta MDSYS.GEOCODE_SERVER_PROPERTY_TYPE := MDSYS.GEOCODE_SERVER_PROPERT;
  5 BEGIN

  6     DBMS_OUTPUT.PUT_LINE('Geocoded address: ');
  7     out_addr := intERactive(meta, in_addr);
  8     DBMS_OUTPUT.PUT_LINE(out_addr(1).city);
  9     DBMS_OUTPUT.PUT_LINE(out_addr(1).country_subdivision);
 10     DBMS_OUTPUT.PUT_LINE(out_addr(1).country);
 11     DBMS_OUTPUT.PUT_LINE(out_addr(1).postal_code);
 12     DBMS_OUTPUT.PUT_LINE(out_addr(1).latitude);
 13     DBMS_OUTPUT.PUT_LINE(out_addr(1).longitude);
 14 END;
 15 /
Geocoded address:
DECLARE
*
ERROR at line 1:
ORA-29541: class SYS.woe/geosoft/geozip/oracleAPI/GeoZip could not be resolved
ORA-06512: at "SYS.INTERACTIVE", line 0 Received on Tue Sep 05 2000 - 14:13:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US