title: Oracle - Log the executed query
body: <p>I have to debug stored procedure which contains a few SQL queries. One of them contains an error. So, I need to execute this SQL query with parameters in other window. I found next query that would help me:</p>
  
  <pre><code>select v.SQL_TEXT
  from v$sql v
  </code></pre>
  
  <p>Unfortunately, this field restricted by 1Kb. In my case I have quite big SQL query and Oracle truncates it. How to log the executed query? I use PL/SQL Developer 10 and Oracle 9i</p>