Sdo_pc_pkg.create_pc Throws Error ORA-00947: Not Enough Values (Doc ID 1550481.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial - Version 12.1.0.1 and later
Information in this document applies to any platform.

Symptoms

When the RES results table (clstPcdataTbl) has extra columns (in this case
"intensity" and "color"), the sdo_pc_pkg.create_pc throws error:

create table res (ptn_id number, point_id number,
rid varchar2(24), val_d1 number, val_d2 number, val_d3 number);

alter table res
add (intensity number);

alter table res
add (color number);


...
 sdo_pc_pkg.create_pc(
  pc, -- Initialized PointCloud object
  'INPTAB', -- Name of input table to ingest into the pointcloud
  'RES' -- Name of output table that stores the points (with
ptn_id,pt_id)
 )
...
...

ERROR at line 1:
ORA-13199: Invalid Parameters for Partition_Table
ORA-13249: Stmt-Execute Failure: INSERT INTO SCOTT.RES (SELECT
a.ptn_id,
a.point_id, b.rid, b.val_d1, b.val_d2, b.val_d3 from MDPCP_1_14278$$$ a,
SCOTT.INPTAB b where a.rid = b.rowid)
ORA-29400: data cartridge error
ORA-00947: not enough values
ORA-06512: at "MDSYS.PRVT_PC", line 3
ORA-06512: at "MDSYS.PRVT_PC", line 158
ORA-06512: at "MDSYS.SDO_PC_PKG", line 74
ORA-06512: at line 32


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms