title: Oracle alter session (internal buffer)
body: <p>I need to set the next date and time format for the next session, something like this:   </p>
  
  <pre><code>alter session set nls_date_format='"Madrid day "DD" of "month" of "YYYY" time: "HH:MI"';
  </code></pre>
  
  <p>But I get the error: "ORA-01801 date format is too long for internal buffer" ...<br>
  Is there any other way to apply this format?</p>