| 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;
![]() |
![]() |