declare
iAppend XMLType;
oAppend schematest.books%ROWTYPE;
begin
  select XMLType(
  '<books>
     <book_id>269</book_id>
     <title>Oracle SQL*Loader</title>
     <author>Jonathan Gennick</author>
  </books>') into iAppend 
  from dual;

   SELECT  BOOK_ID
         , TITLE
         , AUTHOR
   INTO  oAppend.BOOK_ID
         , oAppend.TITLE
         , oAppend.AUTHOR
   FROM XMLTABLE ('/books'--'*'
                  PASSING iAppend
                  COLUMNS   BOOK_ID       number PATH 'book_id/@value'
                          , TITLE       VARCHAR2(4000 CHAR) PATH 'title/@value' 
                          , AUTHOR      VARCHAR2(4000 CHAR) PATH 'author/@value' );
   DBMS_OUTPUT.PUT_LINE(oAppend.BOOK_ID);
 EXCEPTION 
   WHEN NO_DATA_FOUND THEN  DBMS_OUTPUT.PUT_LINE('NO_DATA_FOUND');
   WHEN TOO_MANY_ROWS THEN  DBMS_OUTPUT.PUT_LINE('TOO_MANY_ROWS');  
 
end;

CREATE TABLE SCHEMATEST.books
(
  BOOK_ID  NUMBER,
  TITLE VARCHAR2(4000 CHAR),
  AUTHOR VARCHAR2(4000 CHAR)
)