Re: Very long "WHERE" list.

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sat, 10 Jul 2004 09:24:17 -0700
Message-ID: <1089476673.452434@yasure>

Andy Hassall wrote:

> On Fri, 09 Jul 2004 23:43:05 -0700, Daniel Morgan <damorgan_at_x.washington.edu>
> wrote:
>
>

>>The following is perfectly legal too:
>>
>>BEGIN
>>   dbms_output.put_line(NULL);
>>END;
>>/

>
>
> No, it's not. The NULL here doesn't have a type, and so it'll raise a
> compile-time exception as there's several overloads of put_line and not enough
> information to select one.
>
> dbms_output.put_line('') would at least be legal.
>
>

>>But if you write it you should be fired. 

>
>
> Why is attempting to put blank lines into debug output a cause for dismissal?
>
> --
> Andy Hassall <andy_at_andyh.co.uk> / Space: disk usage analysis tool
> http://www.andyh.co.uk / http://www.andyhsoftware.co.uk/space

Personally I don't allow any program to get past debug stage with dbms_output in it because it is without purpose. But you are incorrect about ('').

SQL> begin

   2 dbms_output.put_line(NULL);
   3 end;
   4 /

PL/SQL procedure successfully completed.

SQL> Daniel Morgan Received on Sat Jul 10 2004 - 11:24:17 CDT