title: How can I set the maximum length of an xmltype?
body: <p>I've created a table with the following: </p>
  
  <pre><code>create table mytable
  (
  primary_key varchar(30),
  Myxml xmltype,
  mydate    DATE   
  );
  </code></pre>
  
  <p>When run <code>describe mytable</code> I get:</p>
  
  <pre><code>Name               Null Type         
  ------------------ ---- ------------ 
  PRIMARY_KEY             VARCHAR2(30) 
  MYXML                   XMLTYPE()    
  MYDATE                  DATE   
  </code></pre>
  
  <p>The problem is, I'm using a propertery software that wants to convert a dataset and upload it to this table, when it run it it gives me a proprietary error: </p>
  
  <p><code>Value too large for column myxml. Max length = 0, actual length = 1721</code></p>
  
  <p>Is there a way that I can manually set the max length of <code>MYXML</code> to avoid this?</p>