Hi, TOM!

Here's my preset:

SQL> create or replace type my_type force is object(
  2    id number,
  3    val varchar2(4000)
  4  )
  5  /
Type created
SQL> set serveroutput on size 999999
SQL> begin
  2    dbms_output.put_line(xmltype(my_type(1, 'VAL')).getstringval);
  3  end;
  4  /
<MY_TYPE><ID>1</ID><VAL>VAL</VAL></MY_TYPE>
PL/SQL procedure successfully completed

Then I try to convert XML to object:

SQL> declare
  2    l_val my_type;
  3  begin
  4    xmltype('<MY_TYPE><ID>1</ID><VAL>VAL</VAL></MY_TYPE>').toobject(l_val);
  5    dbms_output.put_line('l_val.id = ' || l_val.id);
  6    dbms_output.put_line('l_val.id = ' || l_val.val);
  7  end;
  8  /
l_val.id = 1
l_val.id = VAL
PL/SQL procedure successfully completed

Okay, it works well. Then assume that we got corrupted data where tag VAL doesn't exist:

SQL> declare
  2    l_val my_type;
  3  begin
  4    xmltype('<MY_TYPE><ID>1</ID></MY_TYPE>').toobject(l_val);
  5    dbms_output.put_line('l_val.id = ' || l_val.id);
  6    dbms_output.put_line('l_val.id = ' || l_val.val);
  7  end;
  8  /
l_val.id = 1
l_val.id = 
PL/SQL procedure successfully completed

Well, it works fine, we just have our VAL null. Then again we get corrupted data with extra tag FAIL_ATTR:

SQL> declare
  2    l_val my_type;
  3  begin
  4    xmltype('<MY_TYPE><ID>1</ID><VAL>VAL</VAL><FAIL_ATTR>YOU FAIL</FAIL_ATTR></MY_TYPE>').toobject(l_val);
  5    dbms_output.put_line('l_val.id = ' || l_val.id);
  6    dbms_output.put_line('l_val.id = ' || l_val.val);
  7  end;
  8  /
declare
  l_val my_type;
begin
  xmltype('<MY_TYPE><ID>1</ID><VAL>VAL</VAL><FAIL_ATTR>YOU FAIL</FAIL_ATTR></MY_TYPE>').toobject(l_val);
  dbms_output.put_line('l_val.id = ' || l_val.id);
  dbms_output.put_line('l_val.id = ' || l_val.val);
end;
ORA-19031: Элемент или атрибут XML FAIL_ATTR не имеет соответствия в типе IBS.MY_TYPE
ORA-06512: на  "SYS.XMLTYPE", line 196
ORA-06512: на  line 4

It fails!

So here's my question: can I somehow force Oracle to skip such attributes that aren't declared in a type specification? For me it would be okay to miss them.