SECUREFILE keyword missing for BINARY XML

Paul Dziemiela <[email protected]>
Newsgroups gmane.comp.db.oracle.toad.free
Message-ID <93E6FC4F2C85054AA824949283899D2EB191AAD830@HW3SP-EXCHQ1.induscorp.com>
Using Toad 11.0.0.116

CREATE TABLE foo
(
  trans_id         VARCHAR2(2000 BYTE),
  trans_user       VARCHAR2(2000 BYTE),
  trans_xml        SYS.XMLTYPE,
  trans_sdo        MDSYS.SDO_GEOMETRY
)
XMLTYPE trans_xml STORE AS SECUREFILE BINARY XML
VARRAY trans_sdo.SDO_ELEM_INFO STORE AS SECUREFILE LOB (
   ENABLE STORAGE IN ROW
)
VARRAY trans_sdo.SDO_ORDINATES STORE AS SECUREFILE LOB (
  ENABLE STORAGE IN ROW
);

The TOAD script playback misses the SECUREFILE keyword on the BINARY XML but it shows things fine on the VARRAY LOBs.

Note that I cannot actually view BINARY XML in a TOAD query grid without the application crashing (client 11.2.0.1 UTF8 instance).

Cheers,

Paul
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.