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

Home -> Community -> Usenet -> c.d.o.tools -> Re: DBMS_OUTPUT

Re: DBMS_OUTPUT

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 9 Sep 2004 19:12:18 +0200
Message-ID: <41408f08$0$15562$636a15ce@news.free.fr>

"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
Received on Thu Sep 09 2004 - 12:12:18 CDT

Original text of this message

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