Print Thread
Export SYS.XMLTYPE column in PL/SQL Developer format
#52221 10/06/15 04:51 PM
Joined: Jul 2014
Posts: 11
P
PRice2 Offline OP
Member
OP Offline
Member
P
Joined: Jul 2014
Posts: 11
I'd like to use PL/SQL Developer format to export all tables' data. However, one of the tables has a SYS.XMLTYPE column that causes the export to fail.

Is there a fix in the near-term for the problem?

Thanks,


PRice

Re: Export SYS.XMLTYPE column in PL/SQL Developer format
PRice2 #52228 10/07/15 09:35 AM
Joined: Aug 1999
Posts: 22,214
Member
Offline
Member
Joined: Aug 1999
Posts: 22,214
We'll check it out. What exactly goes wrong? Any error messages?


Marco Kalter
Allround Automations
Re: Export SYS.XMLTYPE column in PL/SQL Developer format
Marco Kalter #52236 10/07/15 02:10 PM
Joined: Jul 2014
Posts: 11
P
PRice2 Offline OP
Member
OP Offline
Member
P
Joined: Jul 2014
Posts: 11
The error message is:
[quote]Table XX contains one or more SYS.XMLTYPE columns. Cannot export in PL/SQL Developer format.[/quote]


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.086s Queries: 15 (0.047s) Memory: 2.5009 MB (Peak: 3.0395 MB) Data Comp: Off Server Time: 2024-05-09 09:11:08 UTC
Valid HTML 5 and Valid CSS