Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Very long "WHERE" list.

Re: Very long "WHERE" list.

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sat, 10 Jul 2004 16:48:50 -0700
Message-ID: <1089503345.760506@yasure>


Andy Hassall wrote:

> On Sat, 10 Jul 2004 09:24:17 -0700, Daniel Morgan <damorgan_at_x.washington.edu>
> wrote:
>
> Have a look at my followup post - it turns out it's version dependent. Works
> on 10g, not on 9i. Haven't got 8i handy to try, not used it in a while.
>
> Doing a describe shows that 9i has two overrides for DMBS_OUTPUT.PUT_LINE, one
> taking VARCHAR2 and the other taking NUMBER. Which is ambiguous if you pass
> NULL, so raises a compile-time exception.
>
> Whereas 10g only has one DBMS_OUTPUT.PUT_LINE, taking a VARCHAR2 parameter. So
> it relies on implicit conversion of other types, but removes the ambiguity if
> you pass NULL.
>
> --
> Andy Hassall <andy_at_andyh.co.uk> / Space: disk usage analysis tool
> http://www.andyh.co.uk / http://www.andyhsoftware.co.uk/space

I haven't done anything in 9i for a long time so I didn't even consider that it was a new behavior when I tested it.

Daniel Morgan Received on Sat Jul 10 2004 - 18:48:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US