Re: DBMS_OUTPUT

"David_T MO" <david.thomas_at_cityutilities.net> a écrit dans le message de news:4f6c512c.0409090630.1f1f57f0_at_posting.google.com...
> Thanks guys, that did the trick.
>
> I'll do some more digging for tutorials, etc. from the sites given,
> but I have another quick question. Why, when I execute this test SQL
> script (below), am I getting the message 'Input truncated to 1
> characters'?
>
> ---
>
> DECLARE
>
> BEGIN
>
> if abs( ( sysdate - 1 ) - sysdate ) > 6 then
>
> dbms_output.put_line('Bad Date');
>
> else
>
> dbms_output.put_line('Good Date');
>
> end if;
>
>
> END;
> /
>
> ---
>
> limsd>@u_test_date.sql;
> Input truncated to 1 characters
> Good Date
>
> PL/SQL procedure successfully completed.
>
> ---

Add a new line at the end of the script. The message comes from that the last line is not ended (does not end with chr(10)).

-- 
Regards
Michel Cadot