title: PLSQL CLOBS into variables
body: <p>I'm trying to save a <code>CLOB</code> into a variable to perform operations like extract and such. I have this code:</p>
  
  <pre><code>DECLARE
    clob_rec CLOB;
    n_rec NUMBER:=100;
  BEGIN
    SELECT LOB INTO clob_rec FROM table1 WHERE ID = 1234;
    n_rec := clob_rec.EXTRACT('//XPTO/text()', 'xmlns:XPTO').getNumVal();
  END;
  </code></pre>
  
  <p>I want to save multiple values from the <code>XML</code> to various variables like <code>n_rec</code>. How can get an "instance of the object (CLOB)" to perform functions or methods like <code>extract()</code>?</p>