Re: DBMS_OUTPUT

From: David_T MO <david.thomas_at_cityutilities.net>
Date: 9 Sep 2004 07:30:41 -0700
Message-ID: <4f6c512c.0409090630.1f1f57f0_at_posting.google.com>


[Quoted] 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>_at_u_test_date.sql;
Input truncated to 1 characters
Good Date

PL/SQL procedure successfully completed.

---
Received on Thu Sep 09 2004 - 16:30:41 CEST

Original text of this message