In some cases when running scripts to create sdo or sde metadata you may get an error:
ERROR at line 1:ORA-06531: Reference to uninitialized collection
When you register a layer in the SDO metadata tables (USER_SDO_GEOM_METADATA) using exor procedures, the procedures will try to find the base theme's feature table metadata (the record inUSER_SDO_GEOM_METADATA) and then 'copy' this record for the new theme/view. If the base table ALSO does not have an entry in the USER_SDO_GEOM_METADATA you will get this error.
If you do the safest way to register views in USER_SDO_GEOM_METADATA table is to do it manually:
Basically you will be copying the user_sdo_geom_metadata from the base table to the view. For each view you should be able to find its base theme (and hence the base feature table from the GIS Themes)
For example for a view called AUTOSTRADA_NET_MAP you will copy the settings from the AUTOSTRADA_NET_MAP_TABLE. For each table/view you will need to know its spatial colum. For the above example the spatial column for AUTOSTRADA_NET_MAP is 'GEOM' so you will run:
insert into user_sdo_geom_metadataselect 'AUTOSTRADA_NET_MAP', 'GEOM', diminfo,sridfrom user_sdo_geom_metadatawhere table_name='AUTOSTRADA_NET_MAP_TABLE'
For ANY Nodes layer (e.g. V_NM_NO_ROAD_SDO) you can copy the settings from NM_POINT_LOCATIONS table i.e.
insert into user_sdo_geom_metadataselect 'V_NM_NO_ROAD_SDO', 'GEOLOC', diminfo,sridfrom user_sdo_geom_metadatawhere table_name='NM_POINT_LOCATIONS'
and so on.
After you register all the tables in, you should also register them in ArcSDE. TO do this you will need to know their theme id :
select nth_theme_id from nm_themes_all where nth_feature_table='AUTOSTRADA_NET_MAP'
and then for the theme_id returned you run:
begin nm3sde.register_sde_layer(<theme_id>); end;
Product TechNotes and FAQs
Bentley Technical Support KnowledgeBase
Bentley LEARN Server
Bentley's Technical Support Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!