title: How to view the type of a variable in PL/SQL?
body: <p>Is there a function in PL/SQL to show a variable's exact type, like the DUMP function in SQL?</p>
  
  <p>I've tried the following </p>
  
  <pre><code>DECLARE
     l_variable   INTEGER := 1;
  BEGIN
     DBMS_OUTPUT.PUT_LINE (DUMP (l_variable));
  END;
  </code></pre>
  
  <p>But it gives the following error:</p>
  
  <blockquote>
    <p>PLS-00204: function or pseudo-column 'DUMP' may be used inside a SQL
    statement only</p>
  </blockquote>