title: PL/SQL: ORA-00942: table or view does not exist V$SQL
body: <p>I have created a procedure and used the below statement inside that .</p>
  
  <pre><code>select sql_id into v_sql_id from v_$sql where sql_text =v_sql;
  </code></pre>
  
  <p>I am getting the following error <code>PL/SQL: ORA-00942: table or view does not exist</code></p>
  
  <p>I have checked the synonym its owner is <code>PUBLIC</code>,so it should run in this case ,but its not working .</p>
  
  <p>Another thing i can <code>select sql_id  from v_$sql where sql_text =v_sql;</code> this in simple editor .Can anyone help me with this .</p>