Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Very long "WHERE" list.
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
![]() |
![]() |