2 Replies Latest reply: Dec 10, 2012 8:19 AM by user599560 RSS

    how can i get Extended data type support package  ?

    976897
      i am trying to replicate sdo_geometry datatype object using oracle11gr2 streams but the capture process didnt capture the change made on the table.Thanks in advance for any help

      Edited by: user9104539 on Nov 28, 2012 11:05 PM
        • 1. Re: how can i get Extended data type support package  ?
          hitgon
          Hi,

          User-defined types (including object types, REFs, varrays, and nested tables) is
          Unsupported Data Types for Capture Processes

          Refer the Oracle document
          http://docs.oracle.com/cd/E11882_01/server.112/e17069/ap_restrictions.htm#BABBBIDF

          Regards
          hitgon
          • 2. Re: how can i get Extended data type support package  ?
            user599560
            The docs reference metalink note 556742.1 which appears to contain a link to the software. That being said the note explicitly says:

            Applies to:
            Oracle Server - Enterprise Edition - Version 10.2.0.4 to 11.1.0.7 [Release 10.2 to 11.1]

            Does anyone know if this also applies to 11.2 and the note isn't updated, or is there something already built in 11.2 for streams? The SQLApply note (949516.1) seems to imply it's built in for 11.2 but doesn't mention streams. The 11gR2 Docs still list 556742.1 so I guess I'd assume the note isn't updated.