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>
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