Re: Any ideas why this would be in v$sql?

From: Bosco Ng <boscoklng_at_hotmail.com>
Date: 28 Aug 2003 22:28:30 -0700
Message-ID: <5b606863.0308282128.1b948770@posting.google.com>

Do you or your developers use TOAD or 3rd party tools like that?

Because, as far as I know, some 3rd tools calling OCI has to do SQL like such to verify some irregularities between 8i and 9i CHAR handling.

wizofoz2k_at_yahoo.com.au (Noons) wrote in message news:<73e20c6c.0308281615.a11f854_at_posting.google.com>...
> "select length(chr(2000000000)) from dual"
>
> If I run it, I get "1".
> What the heck could be firing this off?
>
> Obviously, I don't have any SQL anywhere
> with this.
> Any ideas why it would be there?
>
> 8.1.7, Windoze, vanilla system. Websphere
> is running, but I'm told "cross my heart hope
> to die" by the Java folks they don't have
> anything like this anywhere in their code.
>
> TIA. Cheers
> Nuno Souto
> wizofoz2k_at_yahoo.com.au
Received on Fri Aug 29 2003 - 00:28:30 CDT