Sdo_pc_pkg.create_pc Throws Error ORA-00947: Not Enough Values
(Doc ID 1550481.1)
Last updated on FEBRUARY 27, 2019
Applies to:
Oracle Spatial and Graph - Version 12.1.0.1 and laterInformation 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
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |