I have a table with an XMLTYPE column and it contains 3 others virtual columns which use an xmlquery operation on the xmltype column. I am unable to export the dataset of query to insert format, however both CLOB and XMLTYPE are unchecked and Virtual cols is checked in "Columns to exclude" list. T…

As you probably know, you can't insert into virtual columns. Toad automatically excludes them from insert statements. Are you trying to export just the XMLTYPE and CLOB into insert statements? Can you send me your table DDL so I can try to reproduce it?

Yes, I know. For virtual cols exclude option was default OFF, and I checked all of them. The only column type what left was XMLTYPE. I send you the script of table and some sample data .

Export dataset with XMLTYPE column

Toad for Oracle & DevOps Toolkit

JohnDorlon December 9, 2019, 9:56pm 4

Fixed in Toad for Oracle 13.3 Beta

Topic		Replies	Views
ORA-54013: INSERT operation disallowed on virtual columns Toad for Oracle & DevOps Toolkit	4	5402	September 4, 2013
Virtual Columns in Export Dataset from a grid Toad for Oracle & DevOps Toolkit	2	452	October 27, 2022
Toad not generating dummy names for select * when you have xmltype Toad for Oracle & DevOps Toolkit	7	1252	September 28, 2023
14.0.0.538 - "Export Dataset" does not detect schema/table when selecting XMLTYPE columns Toad for Oracle - Beta	7	1412	September 8, 2020
Import XML file for Oracle XMLType Column Toad for Oracle & DevOps Toolkit	0	696	October 31, 2014

Export dataset with XMLTYPE column

Related topics