Knowledge Base - Technical Articles
Error: .ORA-06553: PLS-306: wrong number or types of arguments in call to 'SDO_AGGR_MBR
".ORA-06553: PLS-306: wrong number or types of arguments in call to 'SDO_AGGR_MBR'"
Solution or Workaround
Using a SQL client such as SQL*Plus, execute the CREATE INDEX statement. Provide a name for the spatial index, the name of the ST_Geometry column, grid sizes, and spatial reference ID.
The following example creates a spatial index named crm_idx on a table named cult_rcs, which contains an ST_Geometry named shape. One grid level is used (size=10) and the spatial reference ID is 1.
create index crm_idx on cult_rcs(shape)
indextype is sde.st_spatial_index
Once the spatial index exists, proceed with registering the table with ArcSDE using the sdetable -o register command, or altering the table's registration using the sdetable -o alter_reg command. Consult the ArcSDE Administration Command Reference provided with ArcGIS Server Enterprise for correct syntax and usage of these commands.
Last Modified: 11/25/2009