RE: SECUREFILE keyword missing for BINARY XML

SECUREFILE keyword will be in the next beta.   I was wrong in my first reply when I said it doesn't matter.  You can specify BASICFILE here too.

From: [email protected] [mailto:[email protected]] On Behalf Of Paul Dziemiela
Sent: Monday, January 30, 2012 4:26 PM
To: [email protected]
Subject: [toad] SECUREFILE keyword missing for BINARY XML


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