Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

R4 EA: Error loading a table with an XMLTYPE field

smelzerAug 5 2013 — edited Aug 21 2013

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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 18 2013
Added on Aug 5 2013
#sql-developer
2 comments
466 views