RE: TOAD 11 and XML

Yes, I agree completely!

From: [email protected] [mailto:[email protected]] On Behalf Of Michael Moore
Sent: Thursday, September 29, 2011 2:07 PM
To: [email protected]
Subject: Re: [toad] TOAD 11 and XML



John,
It would be nice if the error message said, "Sorry, Binary XML isn't supported". ;-)

Mike
On Thu, Sep 29, 2011 at 6:19 AM, John Dorlon <[email protected]<mailto:[email protected]>> wrote:

Sorry, Binary XML isn't supported.

From: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Aci Polajnar
Sent: Thursday, September 29, 2011 7:32 AM
To: [email protected]<mailto:[email protected]>
Subject: [toad] TOAD 11 and XML

Hi there

I have installed TOAD 11.0 for ORACLE. Also, I have a table, created like
CREATE TABLE TABLE_XMLBINARY OF XMLType
XMLTYPE store AS BINARY XML;

If I try to open Data tab in SB, I get an error message:




[cid:[email protected]]


If I try to create a new table, like prewius with TOAD 11 I also get an error message

ORA-00900
invalid SQL statement

Cause: The statement is not recognized as a valid SQL statement. This error can occur if the Procedural Option is not installed and a SQL statement is issued that requires this option
(for example, a CREATE PROCEDURE statement). You can determine if the Procedural Option is installed by starting SQL*Plus. If the PL/SQL banner is not displayed, then the option is not installed.

Action: Correct the syntax or install the Procedural Option.

My ORACLE is v11gR2

Regards!
Aci Polajnar
IT svetovalec - IT consultant