Hi Tom.

I've investigating on reasons why getting ORA-31011 when issuing CTAS from dba_hist_sqlbind.

Instruction failing:

create table sqlbind_table
tablespace TBS_NAME
as
select *
from dba_hist_sqlbind;

Raises:
ERROR at line 14:
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00007: unexpected end-of-file encountered


Issue appears to come from the VALUE_ANYDATA column of ANYDATA data type as CTAS from all columns except VALUE_ANYDATA succeeds.

Behavior only comes from instance that has been upgraded from 10.2.0.5 to 12.1.0.2

I've also captured errostack for ORA-31011 but couldn't match any stack from MOS search. File is 20 MB but could extract info to upload here if needed.

Would appreciate any directions to investigate.

Best regards,
Razvan

SQL> create table sqlbind_table
  2  as
  3  select *
  4  from dba_hist_sqlbind
  5  where 1=0;

Table created.

SQL>
SQL>
SQL> set serverout on
SQL> begin
  2  for i in ( select * from dba_hist_sqlbind )
  3  loop
  4    begin
  5      insert into sqlbind_table values i;
  6    exception
  7       when others then
  8          dbms_output.put_line('aggghhh');
  9    end;
 10  end loop;
 11  end;
 12  /

PL/SQL procedure successfully completed.