Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ora-00600 [733] [top call heap] when running plsql query in Oracle Spatial 12.2.0.1.0

woko-OracleMay 4 2019 — edited May 7 2019

Ora-600 error occurs when running a query using parallel processing for a raster image in the Georaster table as a Procedure in 12.2.0.1.0.

what's problem?

SQL>

DECLARE

gr1 sdo_georaster;

gr2 sdo_georaster;

BEGIN

INSERT INTO local_images (image_id, geoimage)

VALUES (2, sdo_geor.init('local_images_rdt'))

RETURNING geoimage INTO gr2;

SELECT geoimage INTO gr1 FROM local_images WHERE image_id=1;

sdo_geor.changeFormatCopy(gr1,

'blocking=OPTIMALPADDING blocksize=(512,512) compression=NONE

interleaving=BIP parallel=2 pyramid=FALSE quality=100', gr2);

UPDATE local_images SET geoimage=gr2 WHERE image_id=2;

COMMIT;

END;

/

DECLARE

*

ERROR at line 1:

ORA-00600: internal error code, arguments: [733], [1131336832], [top call heap], [], [], [], [], [], [], [], [], []

ORA-06512: at "MDSYS.SDO_GEOR_INT", line 2068

ORA-06512: at "MDSYS.SDO_GEOR", line 714

ORA-06512: at "MDSYS.SDO_GEOR", line 1157

ORA-06512: at line 9

Comments
Post Details
Added on May 4 2019
8 comments
677 views