Load a tiff file into georaster.
491324Feb 16 2006 — edited Aug 18 2008Hi
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