title: How to convert XMLTYPE in VARCHAR in ORACLE?
body: <p>I have two columns in my table(TRANSACTION) in ORACLE which are XMLTYPE(XML_IN and XML_OUT). My procedure is not working because I don't know how to convert them to VARCHAR or something(I just think that this is the error). My procedure is:</p>
  
  <pre><code>PROCEDURE SEARCH_XML
  (
      P_ID_TRANSACTION IN TRANSACTION.ID_TRANSACTION%TYPE,
  
      P_CURSOR OUT T_CURSOR
  )
  IS
  BEGIN
  
      OPEN P_CURSOR FOR
  
      SELECT T.XML_IN, T.XML_OUT
      FROM TRANSACTION T
      WHERE T.ID_TRANSACTION = P_ID_TRANSACTION;
  
  END SEARCH_XML;
  </code></pre>
  
  <p>When I call this procedure error message in VisualStudio2008 is: "Unsupported oracle data type USERDEFINED encountered." Any idea how is this working?</p>