title: question about pl/sql stored program text
body: <p>I use TOAD to do my PL/SQL development. In TOAD when i type a procedure name and press f4, I can see this procedure's source code. I think TOAD get the source code from v$sqltext view. To confirm my thought, I wrote a query:</p>
  
  <pre><code>select * from v$sqltext
  </code></pre>
  
  <p>but when I execute the upper query, Oracle give me an error:</p>
  
  <blockquote>
    <p>ORA-00942: table or view does not
    exist
    00942. 00000 -  "table or view does not exist"
    *Cause:<br>
    *Action: Error at Line: 29 Column: 15</p>
  </blockquote>
  
  <p>So I think TOAD get the procedure's source from other place instead of v$sqltext view. Anyone can tell me about this? Great thanks.</p>