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!

Load a tiff file into georaster.

491324Feb 16 2006 — edited Aug 18 2008
Hi

I created a table like this:

create table georaster_table (georid number,extension varchar2(4),rdt_1 sdo_georaster);

then i want to put a tif file into the georaster_table with this script:

DECLARE
geor SDO_GEORASTER;
BEGIN
INSERT INTO georaster_table values( 1, 'TIFF', sdo_geor.init('rdt_1') );
SELECT georaster INTO geor from georaster_table where georid = 1 FOR UPDATE;
sdo_geor.importFrom(geor, NULL, 'TIFF', 'file', 'c:\oracle\raster\georaster_table.tif');
UPDATE georaster_table SET georaster = geor where georid = 1;
COMMIT;
END;/


SQL PLUS gives no error but in the table there is no data added.
Can somebody say what i'm doing wrong.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 15 2008
Added on Feb 16 2006
16 comments
2,775 views