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!

PLS-00707: unsupported construct or internal error [2603] XML%Type

893544Oct 10 2011 — edited Nov 15 2011

I'm currently using SQL Developer 3.0.4 (Details at bottom of thread) and get the following error when compiling a package:

PLS-00707: unsupported construct or internal error [2603]

The problem lies with an IN parameter which has a datatype of mytable.myxmlcolumn%type where the underlying myxmlcolumn has a datatype of SYS.XMLTYPE.

This compile fine in SQL Plus and also in PL/SQL Developer but not in SQL Developer.

Any ideas or assistance would be appreciated.

About
-----

Oracle SQL Developer 3.0.04
Version 3.0.04
Build MAIN-04.34
Copyright © 2005, 2011 Oracle. All Rights Reserved.
IDE Version: 11.1.1.4.37.59.31
Product ID: oracle.sqldeveloper
Product Version: 11.1.2.04.34

Version
-------

Component Version
========= =======
Java(TM) Platform 1.6.0_25
Oracle IDE 3.0.04.34
Versioning Support 3.0.04.34

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 13 2011

Added on Oct 10 2011

#sql-developer

3 comments

1,352 views