Read XML node parsed to table

Hi

I need to read a list of XML files from the server and get the information for an specific node in order to insert it in a custom table.

I have two options to read the xml, both two work fine but I can't read from the table nor the column the specific info that I need.

-Option 1

declare

  dir VARCHAR2(100);

  file VARCHAR2(100);

  name VARCHAR2(100);

  theBFile   BFILE;

  theCLob    CLOB;

  theDocName VARCHAR2(200) := NVL(name,file);

  x XMLTYPE;

 

  src_offset number:=1;

  dest_offset number:=1;

  lang_ctx number:=dbms_lob.default_lang_ctx;

  warning integer;

 

BEGIN

  -- (3) Get a BFile handle to the external file