GDAL: GDALOpen(/var/folders/ZY/ZYWzFUKXEbOEGREoz1h7QU+++TQ/-Tmp-/tmpfZHUHd.vrt, this=0x10301b970) succeeds as VRT.
OGRCT: PROJ >= 4.8.0 features enabled
OGRCT: Source: +proj=utm +zone=15 +datum=WGS84 +units=m +no_defs
OGRCT: Target: +proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +wktext  +no_defs
OGRCT: Source: +proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +wktext  +no_defs
OGRCT: Target: +proj=utm +zone=15 +datum=WGS84 +units=m +no_defs
GDAL: GDALOpen(/var/folders/ZY/ZYWzFUKXEbOEGREoz1h7QU+++TQ/-Tmp-/tmpfZHUHd_warp.vrt, this=0x103019260) succeeds as VRT.
GDAL: QuietDelete(georaster:test_lidar,Im_a_lumberjack,lidar/orcl,lidar_rasters,raster) invoking Delete()
GDAL: GDALOpen(georaster:test_lidar,Im_a_lumberjack,lidar/orcl,lidar_rasters,raster, this=0x10302cdc0) succeeds as GeoRaster.
PL/SQL:
DECLARE
  TAB VARCHAR2(68)  := UPPER('lidar_rasters');
  COL VARCHAR2(68)  := UPPER('raster');
  OWN VARCHAR2(68)  := UPPER('test_lidar');
  CNT NUMBER        := 0;
BEGIN
  EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM ALL_TABLES
    WHERE TABLE_NAME = :1 AND OWNER = UPPER(:2)'
      INTO CNT USING TAB, OWN;

  IF CNT = 0 THEN
    EXECUTE IMMEDIATE 'CREATE TABLE lidar_rasters (raster MDSYS.SDO_GEORASTER)';
    SDO_GEOR_UTL.createDMLTrigger( TAB,  COL );
  END IF;
END;

PL/SQL:
DECLARE
  TAB  VARCHAR2(68)    := UPPER('lidar_rasters');
  COL  VARCHAR2(68)    := UPPER('raster');
  OWN  VARCHAR2(68)    := UPPER('test_lidar');
  CNT  NUMBER          := 0;
  GR1  SDO_GEORASTER   := NULL;
BEGIN

  GR1 := SDO_GEOR.createBlank(20001, SDO_NUMBER_ARRAY(0, 0), SDO_NUMBER_ARRAY(152, 249), 0, 'TEST_LIDAR_RASTER_DATA', NULL);

  GR1.spatialExtent := NULL;

  INSERT INTO lidar_rasters VALUES (6,3,1,GR1) RETURNING raster INTO GR1;

  SELECT GR1.RASTERDATATABLE INTO :rdt FROM DUAL;
  SELECT GR1.RASTERID        INTO :rid FROM DUAL;

  EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM ALL_OBJECT_TABLES
    WHERE TABLE_NAME = :1 AND OWNER = UPPER(:2)'
      INTO CNT USING :rdt, OWN;

  IF CNT = 0 THEN
    EXECUTE IMMEDIATE 'CREATE TABLE '||:rdt||' OF MDSYS.SDO_RASTER
      (PRIMARY KEY (RASTERID, PYRAMIDLEVEL, BANDBLOCKNUMBER,
      ROWBLOCKNUMBER, COLUMNBLOCKNUMBER))
      LOB(RASTERBLOCK) STORE AS (NOCACHE NOLOGGING)';
  END IF;

  SDO_GEOR.createTemplate(GR1, 20001, 'dimSize=(152,249) blockSize=(256, 256) cellDepth=32BIT_REAL interleaving=BSQ compression=NONE', null, 'TRUE');

  UPDATE lidar_rasters T SET raster = GR1 WHERE
    T.raster.RasterDataTable = :rdt AND
    T.raster.RasterId = :rid;

  EXECUTE IMMEDIATE
    'SELECT T.raster.METADATA.getClobVal()
     FROM   lidar_rasters T
     WHERE  T.raster.RASTERDATATABLE = UPPER(:1)
       AND  T.raster.RASTERID = :2'
      INTO  :metadata
     USING  :rdt, :rid;

  COMMIT;

END;


ERROR 1: ORA-13442: GeoRaster object not registered: RDT=TEST_LIDAR_RASTER_DATA, RID=284
ORA-06512: at "MDSYS.SDO_GEOR_INT", line 2348
ORA-06512: at "MDSYS.SDO_GEOR", line 1685
ORA-06512: at line 29

ERROR 1: Failure to initialize GeoRaster
GDAL: GDALClose(georaster:test_lidar,Im_a_lumberjack,lidar/orcl,lidar_rasters,raster, this=0x10302cdc0)
GDAL: GDALClose(/var/folders/ZY/ZYWzFUKXEbOEGREoz1h7QU+++TQ/-Tmp-/tmpfZHUHd.vrt, this=0x10301b970)
GDAL: GDALClose(raster/fixtures/test.img, this=0x10301bc00)
GDAL: GDALClose(raster/fixtures/test2.img, this=0x10301bf40)
GDAL: GDALClose(/var/folders/ZY/ZYWzFUKXEbOEGREoz1h7QU+++TQ/-Tmp-/tmpfZHUHd_warp.vrt, this=0x103019260)
GDAL: In GDALDestroy - unloading GDAL shared library.