Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> missing class
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;