In the Toad editor, create the following table:
CREATE TABLE test
(
XMLTYPE_COL SYS.XMLTYPE DEFAULT ''
)
Then go to the Script tab for the newly created table. Toad shows the following statement:
CREATE TABLE test
(
XMLTYPE_COL SYS.XMLTYPE Generated Always as ('')
)
Trying to create a table with the "Generated Always as" option leads to the following error:
'ORA-54003: specified data type is not supported for a virtual column'
Toad seems to be generating an invalid create script in this circumstance.
WORKAROUND:
None.
STATUS:
Waiting for fix in a future release of Toad for Oracle