2 Replies Latest reply on Mar 19, 2002 2:02 PM by tejo

    Oracle9i SYS.XMLTYPE

    tejo

      Hi Folks,

      I am using JBoss-2.4.4 and Oracle 9i. Our XML
      docs are big and we store them in table
      as XMLTYPE datatype.

      When I run a SQL query using oracle's extract function,
      things run fine on low volumes. If the row
      count exceeds 250-300 I get an ORA error.

      ORA-04031: unable to allocate 8192 bytes of
      shared memory ("large pool","unknown object","","subheap")
      ORA-06512: at "SYS.XMLTYPE", line 0

      Any help ????....

      Thanks,
      Tejo