Re: 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]> wrote:

> **
>
>
>  Sorry, Binary XML isn’t supported.  ****
>
> ** **
>
> *From:* [email protected] [mailto:[email protected]] *On Behalf Of *Aci
> Polajnar
> *Sent:* Thursday, September 29, 2011 7:32 AM
> *To:* [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:****
>
> ****
>
>  ****
>
>
> 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*****
>
>
>
> ****
>
>  
>