Error messagenya very clear,
DECLARE
shape mdsys.sdo_geometry; --> tambahkan semicolon(';') setiap deklarasi
variable
hth,
AH
Rianti Hastuti wrote:
>
> 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
> <http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7>
>
> [Non-text portions of this message have been removed]
>
>
