ORA-00904: "OTHER_XML": invalid identifier When Running Dbms_spm.pack_stgtab_baseline (Doc ID 2680400.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

• When running dbms_spm.pack_stgtab_baseline you may see an error
  
  This XML error from a valid syntax of a call to pack_stgtab_baseline

  exec :pls:= dbms_spm.pack_stgtab_baseline(table_name=>'TABLE_NAME', table_owner=>'SCHEMA_NAME',sql_handle=>'SQL_HANDLE')
  
  ERROR at line 1:
  ORA-00904: "OTHER_XML": invalid identifier
  ORA-06512: at "SYS.DBMS_SMB", line 789
  ORA-06512: at "SYS.DBMS_SPM", line 2229
  ORA-06512: at line 1

    
  

   

Changes

 An upgrade was done between creating the Staging Table and using the Staging Table.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.