Re: DBMS_OUTPUT

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.

---
Received on Thu Sep 09 2004 - 09:30:41 CDT