[lidar@rsgisvmw02 gdal]$ las2oci --block-table-name lidar_block --t_srs EPSG:4326+4326 --global-extent 180.0,-90.0,180.0,90.0 --block-capacity 5000 --offset '0 0 0' --srid 4326 --post-sql "begin execute immediate 'alter procedure build_max_density compile'; build_max_density; end;" --scale 0.0000001 0.0000001 0.0001 -c lidar/lidar@rsgisvmw02.crrel.usace.army.mil/orcl --base-table-name lidar_base_pc --header-blob-column header  -i /u02/LASdata/Office_of_Americas/Concord_NH/LAS/0101.las  --cloud-column-name pc  --a_srs EPSG:26919+4326 --debug
Opening /u02/LASdata/Office_of_Americas/Concord_NH/LAS/0101.las to fetch header
Setting output base table to: lidar_base_pc
Setting output block table to: lidar_block
Setting output point cloud column to: pc
Setting header blob column to: header
Setting block capacity to: 5000
Setting precision to: 8
Setting output Oracle SRID to: 4326
Setting output post-sql to: begin execute immediate 'alter procedure build_max_density compile'; build_max_density; end;
Setting offsets to: 0 0 0
Setting scales to: 1e-07 1e-07 0.0001
Setting input SRS to 'EPSG:26919+4326'
Setting output SRS to EPSG:4326+4326
GDAL Debug: OGRCT: Source: +proj=utm +zone=19 +ellps=GRS80 +towgs84=0,0,0,0,0,0,0 +units=m +no_defs
GDAL Debug: OGRCT: Target: +proj=longlat +datum=WGS84 +no_defs
GDAL Debug: OGRCT: Source: +proj=utm +zone=19 +ellps=GRS80 +towgs84=0,0,0,0,0,0,0 +units=m +no_defs
GDAL Debug: OGRCT: Target: +proj=longlat +datum=WGS84 +no_defs
Connecting with username: lidar password: lidar instance: rsgisvmw02.crrel.usace.army.mil/orcl
Base table name lidar_base_pc cloud column: pc block table: lidar_block
Oracle connection succeded
GDAL Debug: PL/SQL:
select table_name from user_tables where table_name like upper('%%lidar_block%%')

Using existing block table ...
Chipping data for loading into Oracle with 5000 block capacity
GDAL Debug: PL/SQL:
SELECT COORD_REF_SYS_KIND from MDSYS.SDO_COORD_REF_SYSTEM WHERE SRID = :1

GDAL Debug: PL/SQL:
declare
  pc_id NUMBER := :1;
  pc sdo_pc;
begin
  -- Initialize the Point Cloud object.
  pc := sdo_pc_pkg.init(
          'LIDAR_BASE_PC', -- Table that has the SDO_POINT_CLOUD column defined
          'PC',   -- Column name of the SDO_POINT_CLOUD object
          'LIDAR_BLOCK', -- Table to store blocks of the point cloud
           'blk_capacity=5000', -- max # of points per block
           mdsys.sdo_geometry(2003, 4326, null,
              mdsys.sdo_elem_info_array(1,1003,3),
              mdsys.sdo_ordinate_array(
-71.6388,43.3043,-71.6137,43.323)),  -- Extent
     0.5, -- Tolerance for point cloud
           5, -- Total number of dimensions
           null);
  :1 := pc.pc_id;
  -- Insert the Point Cloud object  into the "base" table.
  insert into LIDAR_BASE_PC ( ID, PC,HEADER) values ( pc.pc_id, pc, :1);
  end;


error: GDAL Failure number=1: ORA-01036: illegal variable name/number