Error: .ORA-06553: PLS-306: wrong number or types of arguments in call to 'SDO_AGGR_MBR
When registering with ArcSDE an Oracle table containing an ST_Geometry column or altering the registration of a feature class in Oracle containing an ST_Geometry column, the following error message may occur:
".ORA-06553: PLS-306: wrong number or types of arguments in call to 'SDO_AGGR_MBR'"
This error message is itself an error; spatial type tables do not use Oracle Spatial calls (in this case, SDO_AGGR_MBR).
This is a known issue in ArcSDE 9.2.
Solution or Workaround
Create a spatial index on the ST_Geometry column in the business table of the feature class before registering the feature class with ArcSDE or altering the feature class’ registration.
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.