title: How do I get the return value from a function in Oracle using Toad
body: <p>How do I find out in Toad what the return value of a function is?</p>
  
  <p>I'm running something like this code:</p>
  
  <pre><code>declare r number;
  begin
      r:= packagename.functionname(paraname);
  end;
  </code></pre>
  
  <p>I can't work out how to get "r" returned to the data grid, some posts suggest using DBMS output but nothing is written to it when I run the code.</p>
  
  <p>The function performs updates, commits, calls other functions and has cursors in it.</p>