2 Replies Latest reply: Aug 21, 2013 10:15 AM by Jeff Smith Sqldev Pm-Oracle RSS

    R4 EA: Error loading a table with an XMLTYPE field


      When I try to view the data in a table with an XMLTYPE field I get the following error in R4 EA Version Build MAIN-12-27.  This works in 2.2 and 3.0.



           Error: Resource not found: ${SCRATCH_COMMAND_ICON}.


      Double clicking on the error opens the EXTENSION.XML file and shows this line:


      <trigger-hooks xmlns="http://xmlns.oracle.com/ide/extension">

        <!-- Add registry here if required -->

        <triggers xmlns:c="http://xmlns.oracle.com/ide/customization">

          <actions xmlns="http://xmlns.oracle.com/jdeveloper/1013/extension">

            <action id="MigrationProject.ApplicationScan">


                <property name="Name">${APPSCAN_TITLE}</property>

                <property name="MnemonicKey">${APPSCAN_TITLE2}</property>

                <property name="SmallIcon">res:${SCRATCH_COMMAND_ICON}</property>





      The table has the following definition:

      ID    NUMBER(38,0)    No

      WS_DATA    XMLTYPE    Yes

      WS_SNAPSHOT_ID    NUMBER(38,0)    No


      Any help would be greatly appreaciated.  We have to upgrade to 4.0 because our security team will no longer allow Java 6 on any server or workstation.