title: How to retrieve sql text of cursor?
body: <p>If I have a cursor and would like to log the text of the cursor during execution is it possible to use the cursor name in some way and retrieve the SQL?  </p>
  
  <p>For example, </p>
  
  <pre><code>OPEN cursor_1 for 
      SELECT ...
  </code></pre>
  
  <p>I'd like to believe I can do something like <code>cursor_1%NAME</code> much like I can use the other attributes of a cursor. (<a href="http://docs.oracle.com/cd/B14117_01/appdev.101/b10807/13_elems011.htm" rel="nofollow">%ISOPEN, %FOUND</a>, etc.).</p>