assalamualaikum
buat semua temen-temen yang sudah berkenan menjawab pertanyaan saya, saya
ucapkan banyak2 terima kasih
saya punya script union untuk menggabungkan beberapa polygon. berikut
scriptnya, tapi ada pesan errornya. saya kurang mengerti di mana letak
kesalahannya. mohon bantuannya. terima kasih
DECLARE
shape mdsys.sdo_geometry
coverage mdsys.sdo_geometry := null;
BEGIN
OPEN cur FOR SELECT shape FROM podes;
LOOP
EXIT WHEN cur%NOTFOUND;
FETCH cur INTO shape;
coverage := SDO_GEOM.SDO_ UNION(coverage, shape);
END LOOP;
EXECUTE IMMEDIATE 'INSERT INTO podes_coverage values (:1)' -----saya
tidak mengerti di sini, mohon bantuannya
USING coverage;
COMMIT;
END;
dan pesan errornya:
ERROR at line 3:
ORA-06550: line 3, column 1:
PLS-00103: Encountered the symbol "COVERAGE" when expecting one of the
following:
:= . ( @ % ; not null range default character
The symbol ";" was substituted for "COVERAGE" to continue.
____________________________________________________________________________________
Shape Yahoo! in your own image. Join our Network Research Panel today!
http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7
[Non-text portions of this message have been removed]
