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

    smelzer

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

       

      oracle.sqldeveloper.migration.application

           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">

              <properties>

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

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

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

              </properties>

            </action>

          </actions>

       

      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.

       

      Thanks,

      Steve