English

Error: .ORA-06553: PLS-306: wrong number or types of arguments in call to 'SDO_AGGR_MBR

Error Message

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'"

Note:
This error message is itself an error; spatial type tables do not use Oracle Spatial calls (in this case, SDO_AGGR_MBR).

Cause

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.

Code:
create index crm_idx on cult_rcs(shape)
indextype is sde.st_spatial_index
parameters('st_grids=10,0,0 st_srid=1');

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.